countifs formula help
Options
Y Mattos
✭
I am trying to Count # of tasks if the task meets multiple criteria. For example, the task is green, it happened in the 2 quarter and it's in the metrics workstream. I get an Invalid Ref error in the formula. I am only counting tasks from the same sheet. Formula is below:
=COUNTIFS({Health}, "Red", {Quarter}, "Q2", {Workstream}="Metrics")
Thanks,
Y.
Tags:
Comments

You are simply missing a comma between your final range and criteria...
=COUNTIFS({Health}, "Red", {Quarter}, "Q2", {Workstream}, "Metrics")
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!