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?
Tags:
Best Answers

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)

It worked!!! Thank you!
Answers

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)

It worked!!! Thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!