formula query for count if all x1,x2,x3 columns contain a1 or b1 inputs.

usha

Hi , I need to write formula for below mentioned requirement.

x1 column has any of a1 or b1

& x2 column has any of a1 or b1

& X3 column has any of a1 or b1

Count the total rows returned with above condition

Thanks

Find more posts tagged with

Accepted answers

All comments

Ibrahim Khaleel

Please try below formula, Replace your column name with X1, X2 and X3

==countifs(X1:X1,="a1", X1:X1,="b1") + countifs(X2:X2,="a1", X2:X2,="b1") + countifs(X3:X3,="a1", X3:X3,="b1")

usha

Thank you

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.