Count two different combinations of criteria.
This formula works for one combination of "HWMP" + "Notice Package Approval"
=COUNTIFS({Regulations Development Range 5}, CONTAINS("Notice Package Approval", @cell), {Regulations Development Range 3}, "HWMP")
I'm trying to expand it to count two combinations:
"HWMP" + "Notice Package Approval"
"HWMP" + "Pre-Comment Period Review"
I've tried adding an OR formula, such as CONTAINS(OR(("Notice Package Approval", @cell),("Pre-Comment Period Review", @cell)), but it's unparsable.
Best Answer
-
Try this...
=COUNTIFS({Regulations Development Range 5}, OR(CONTAINS("Notice Package Approval", @cell), CONTAINS("Pre-Comment Period Review", @cell)), {Regulations Development Range 3}, "HWMP")
Answers
-
Try this...
=COUNTIFS({Regulations Development Range 5}, OR(CONTAINS("Notice Package Approval", @cell), CONTAINS("Pre-Comment Period Review", @cell)), {Regulations Development Range 3}, "HWMP")
Help Article Resources
Categories
Check out the Formula Handbook template!