Countif except N/A's

I have two columns that I'm trying to build a countif function for. First column has a value: A,B,C. Second column is checkboxes with N/A if the team member is not required to complete. End result I would like to get a final count of all the A's that are required to complete the training.

=countifs(columnA:columnA, "A", columnB:columnB, <> "N/A")

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Rayme

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS(columnA:columnA, @cell = "A", columnB:columnB, NOT(@cell = "N/A")), "")

the following screenshot shows the result:

All comments

Bassam Khalil

Hi @Rayme

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS(columnA:columnA, @cell = "A", columnB:columnB, NOT(@cell = "N/A")), "")

the following screenshot shows the result:

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