Nested CountIf function
Hi there.
Is there a such thing as a nested countif function?? I'm aware of how to use the countif in smartsheet...
=COUNTIF({ Test Sheet Range 3}, "Approved")
Suppose I want to count records with more than 1 criterion?
Status = Approved
Stage = Stage 1
How would I craft that out? Is it a nested CountIF function??
Thanks, SB
Tags:
Best Answer
-
Check out the COUNTIFS function.
=COUNTIFS(range1, criteria 1, range 2, criteria 2, ........................................)
Answers
-
Check out the COUNTIFS function.
=COUNTIFS(range1, criteria 1, range 2, criteria 2, ........................................)
-
Thank you. I watched the video in one of the articles.
SB
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!