Formula help

Question

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")

David Joyeuse · Accepted Answer

Hi @Rebecca Wilhelm

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!