Multiple Criteria

tofani

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)

Find more posts tagged with

Accepted answers

All comments

Steven Stikons

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

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.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.