COUNTIFS - blank search input in 1 of 2 criteria

=IFERROR(COUNTIFS({2025 Tracker v2 | Brand}, "Apple", {2025 Tracker v2 | Status}, [Primary Column]@row, {2025 PMO Tracker v2 | Year}, $[Primary Column]$1), "")

Year is 2025 and @primary row is blank, however it still returns 280 items when there are no blanks items to count in Status.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context? Have you applied a filter to the source sheet matching the range/criteria sets to see what comes up?

JAAS

Paul, I have a sheet I collect data in from many sheets in order to create custom reports. So the formula and search criteria are in this sheet and is pulling data from other sheets.

The brand matches - "Apple"

Status - no empty status cells that match the other 2 criteria, but I need to know there are so we can flag people to enter this.

Year matches - "2025"

This gets 280 matches - there should be 0

=IFERROR(COUNTIFS({2025 Tracker v2 | Brand}, "Apple", {2025 Tracker v2 | Status}, [Primary Column]@row, {2025 Tracker v2 | Year}, $[Primary Column]$1), "")

Paul Newcome

Ok. Did you try a filter on the source sheet that this formula is referencing? Are you able to provide some screenshots for context?

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.