Multiple Criteria

tofani · 07/16/21

I'm trying to apply COUNTIFS condition with multiple criteria with same column:

Column (assigned to): abcd@xyz.com

Column (stage): is not one of --> blank and approved

Column (product stage): is not one of --> blank and 0

=COUNTIFS({SF PM Data Range 3}, "abcd@xyz.com", {SF PM Data Range 5}, <>"", {SF PM Data Range 4}, "0)

Steven Stikons · 07/16/21

You are missing a close quote on your last criteria ("0). Also, quotes aren't required on quantities and will error out unless the quantity is actually a string.

tofani · 07/16/21

https://community.smartsheet.com/discussion/comment/298234#Comment_298234

it's still not working...it's showing me 0 found instead of my filter shows 296 raw found

Genevieve P. · 07/19/21

Hi @tofani,

It sounds like for your last criteria you want to check if it's not something, however your current formula is checking if it IS 0.

Try this:

=COUNTIFS({SF PM Data Range 3}, "abcd@xyz.com", {SF PM Data Range 5}, <> "", {SF PM Data Range 4}, AND(@cell <> 0, @cell <> ""))

This will see if the {SF PM Data Range 4} column is not 0 AND is not blank.

If this doesn't work, it would be useful to see a screen capture of your source sheet where the data is stored, but please block out any sensitive information.

Cheers,

Genevieve

Multiple Criteria

Answers

Help Article Resources

Categories