Countifs syntax killing me

Shawn Borror

I want to count number of projects on hold AND change control = resource constraints

This is what I"ve tried;

=COUNTIFs([Portfolio Rollups Range 8], "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")

Paul Newcome

You should be using curly brackets instead of straight around your first range the same way you have in the second range.

Shawn Borror

=COUNTIFs({Portfolio Rollups Range 8} "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")

still gives me unparsable error :(

Paul Newcome

You are accidentally deleted the comma between the first range and the first criteria.