#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# COUNTIFS on the same column

edited 12/09/19

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?

• ✭✭✭✭✭✭

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

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

• edited 12/20/16

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")

• edited 12/20/16

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

Anyone else!

• ✭✭✭✭✭✭
edited 12/20/16

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.

• edited 12/21/16

Thanks James for clarifying.

This discussion has been closed.