COUNTIFS Column A is blank and Column B does not contain 1

Hi All,

I am struggling to make the COUNTIFS formula work in a Sheet Summary Field where Column A is blank and Column B does not contain 1. NOTE: Column B is a formula column with the following - =COUNT(ANCESTORS([Risk Number]@row)).

=COUNTIFS([Column A]:[Column A], "", [Column B]:[Column B], NOT(CONTAINS("1", @cell)))

Additionally, what would the formula be if I'm looking to count rows where Column A is blank and Column B contains "2" or "3"?

Any assistance would be appreciated!

Find more posts tagged with

Formulas

Accepted answers

All comments

heyjay

=COUNTIFS(
[Column A]:[Column A], "", 
[Column B]:[Column B], FIND( [Column B]:[Column B], 1) = 0
)

I used FIND function to look for cells that is not equal to 1.

Replace 1 with your new query (2 or 3).

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.