COUNTIFS on the same column

Sean Flynn

Hi,

 

I'm trying to create a formula, which runs a count on a particular column

 

e.g. 'Status' column, with values of 'In Progress', 'Build' and 'QA'. I would like to find the total number of projects that have a status of:

 

'In Progress' and 'Build' 

 

I'm using the COUNTIFS formula, however no luck so far.

 

Any ideas would be greatly appreciated?

ricki

I tried the following and it worked as expected. How is your formula different?

 

=COUNTIF(Status436:Status449, "In Progress")+COUNTIF(Status436:Status449, "Build")

Sean Flynn

Hi ricki,

 

This formula works (21):

=COUNTIFS(Status:Status, "Build") 

 

However, when I add a second value, it gives a 0 value as the answer as opposed to adding both variables (30):

 

=COUNTIFS(Status:Status, "Build", Status:Status, "QA")

 

Any suggestions?

ricki

can you do what i did above countif + countif instead of using countifs?

 

=COUNTIF(Status:Status, "Build") + COUNTIF(Status:Status, "QA") 

Sean Flynn

Hi ricki, thanks that worked, much appreciated. I'm still intrigued to see how to the COUNTIFS function works!

 

Anyone else! 

ricki

i tried the countifs in excel and also got 0. I have a feeling that countifs is an AND rather than an OR over all conditions.

 

Sean Flynn

Yeah, that sems to be the case, thanks Ricki.

JamesR

Countifs expect the Lookup column to be different for each criteria.

 

Countif looks up 1 value in one column, Countifs lookup multiple values in multiple columns.

 

 

Sean Flynn

Thanks James for clarifying.