COUNIF Range with two requirements?

Hi all,

This feels like it should be rather simple but I am getting an incorrect argument set. The formula I am using is: =COUNTIFS(Building:Building, Location@row, [SignageA]:[SignageD], "Yes")

Basically, there are multiple columns for the signage that we need to check and compare it to the location so we can have a roll up by building on how many have been set up.

Is there something glaringly obvious that I am missing?

Find more posts tagged with

Accepted answers

Mike Wilday

You have to check each column individually.

Try this revision:

=COUNTIFS(Building:Building, Location@row, OR(@cell([SignageA]:[SignageA]), "Yes", @cell([SignageB:[SignageB]), "Yes", @cell([SignageC]:[SignageC]), "Yes", @cell([SignageD]:[SignageD]), "Yes")\

Let me know if it works.

All comments

Mike Wilday

You have to check each column individually.

Try this revision:

=COUNTIFS(Building:Building, Location@row, OR(@cell([SignageA]:[SignageA]), "Yes", @cell([SignageB:[SignageB]), "Yes", @cell([SignageC]:[SignageC]), "Yes", @cell([SignageD]:[SignageD]), "Yes")\

Let me know if it works.

Ryan Nix

Looks like that helped, thanks!

Mike Wilday

Awesome, glad I could help you out.

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.