How to create a formula to count # of values in a multi-value cell + other criteria using COUNTIFS?

Hello, I'm trying to count a value from a multi-value cell considering more than one criteria located in other columns.

I'm trying using this formula: =COUNTIFS([LSP Name]:[LSP Name], CONTAINS("CNWQ", @cell), Active:Active, CONTAINS("Active", @cell), Function:Function, CONTAINS("MULTIPLE", @cell)) but is not working. Is not returning an error, but is not counting.

Thanks

Find more posts tagged with

Accepted answers

AravindGP

Hi @PauSanHPE

Count ifs will return a result only if all the criteria you've in the formula is met. It is similar to AND. Does the LSP Name column contain the value CNWQ in at least one cell? If not, try adding it and you will get a result.

All comments

Adam Murphy

Try this: =COUNTIFS([LSP Name]:[LSP Name], HAS(@cell, "CNWQ"), Active:Active, "Active", Function:Function, "MULTIPLE")

AravindGP

Hi @PauSanHPE

PauSanHPE

Hello guys,

I just noted that I used the incorrect LSP Name, that is why it didn't return any value.

Thank you so much.

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.