countifs formula help

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.

 

Paul Newcome

You are simply missing a comma between your final range and criteria...

 

=COUNTIFS({Health}, "Red", {Quarter}, "Q2", {Workstream}, "Metrics")