COUNTIFS across columns with multiple options for one column

I am trying to write a formula to count the number of columns across five nonadjacent columns that contain "Verified". The fifth column may contain "N/A" and also needs to be counted.

In the example, 5 should be the total count for both rows. I've tried adding multiple COUNTIFS, and it doesn't work.

Thanks in advance for your help.

Lori F.

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

@Lori Flanigan

Try this. Each one of the COUNTIF formulas should equal 1 or 0.

=COUNTIF(A@row, "Verified") + COUNTIF(B@row, "Verified) + COUNTIF(C@row, "Verified") + COUNTIF(D@row, "Verified) + COUNTIF(E@row, OR(@cell = "Verified", @cell = "N/A"))

All comments

Jeff Reisman

@Lori Flanigan

Try this. Each one of the COUNTIF formulas should equal 1 or 0.

=COUNTIF(A@row, "Verified") + COUNTIF(B@row, "Verified) + COUNTIF(C@row, "Verified") + COUNTIF(D@row, "Verified) + COUNTIF(E@row, OR(@cell = "Verified", @cell = "N/A"))

Lori Flanigan

Thank you, Jeff! The OR part of the formula is what kept tripping me up. This worked. Much appreciated!

Lori

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.