Formula help
I would like to create an equation to count based on specific criteria.
The attached image is my criteria.
Currently my formula is:
=COUNTIFS(CONTAINS("", {Project Clean Slate Case Management Range 1}) + CONTAINS("", {Project Clean Slate Case Management Range 2}) {Project Clean Slate Case Management - Status}, "Waiting on Records") + COUNTIFS({Project Clean Slate Case Management - Status}, "Waiting on Client")
Best Answer
-
So that should be something like this:
=COUNTIFS({Project Clean Slate Case Management Range 1}, ISBLANK(@cell), {Project Clean Slate Case Management Range 2}, ISBLANK(@cell), {Project Clean Slate Case Management - Status}, OR(@cell = "Waiting on Records", @cell = "Waiting on Client"))
Hope it helped!
Answers
-
So that should be something like this:
=COUNTIFS({Project Clean Slate Case Management Range 1}, ISBLANK(@cell), {Project Clean Slate Case Management Range 2}, ISBLANK(@cell), {Project Clean Slate Case Management - Status}, OR(@cell = "Waiting on Records", @cell = "Waiting on Client"))
Hope it helped!
-
THANK YOU!
Help Article Resources
Categories
Check out the Formula Handbook template!