Tuesday 1 May 2018

microsoft excel - how to pass a string value into COUNTIF?


For this formula:


=COUNTIF(A1:A10,"jim") 

how can I pass in a variable? That is, let's say that cell C11 has the value "jim"; can I then do something like:


=COUNTIF(A1:A10,TEXT_VALUE_OF_CELL(C11)) 

for the same result?



Answer



The cell reference acts as a variable: =COUNTIF(A1:A10,C11)


No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...