COUNTIFS on the same column

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?

Find more posts tagged with

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

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

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?

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

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

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

Anyone else!

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.

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

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.