Countifs syntax killing me
Options
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")
Tags:
Answers
-
You should be using curly brackets instead of straight around your first range the same way you have in the second range.
-
=COUNTIFs({Portfolio Rollups Range 8} "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")
still gives me unparsable error :(
-
You are accidentally deleted the comma between the first range and the first criteria.
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!