Adding a COUNTIF to a COUNTIFS formula?

CJB

I have a COUNTIFS formula... =COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell)). I have another formula that I need to add to the =COUNTIFS forumula... it's =COUNTIF(Level:Level, =0) . How would I combine the two?

Parker Oxford

The formula below will count the cells where both criteria are met.

=COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell),Level:Level, =0)

if your goal is to add up the 2 results found by each COUNTIF, use the following formula

=COUNTIF(Status:Status, CONTAINS("In Progress - On Track", @cell)) + COUNTIF(Level:Level, =0)

CJB

It worked!!! Thank you!

Parker Oxford

The formula below will count the cells where both criteria are met.

=COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell),Level:Level, =0)

if your goal is to add up the 2 results found by each COUNTIF, use the following formula

=COUNTIF(Status:Status, CONTAINS("In Progress - On Track", @cell)) + COUNTIF(Level:Level, =0)

CJB

It worked!!! Thank you!