Formula to count both names in one column for year 2023

Hello,

I'm trying to count a total of two (Ronler Acres and Portfolio/Ronler Acres) in a column for year 2023. Can someone please assist me please? Thanks in advance!!

=COUNTIFS({Copy of Change Request Range 1}, "Ronler Acres", AND(@cell = "Ronler Acres/Portfolio", {Copy of Change Request Range 9}, IFERROR(MONTH(@cell), 0) = 1, {Copy of Change Request Range 9}, IFERROR(YEAR(@cell), 0) = 2023))

Find more posts tagged with

Accepted answers

Jeff Reisman

@Nkeiruka. Aguocha If you want to look for rows that contain either of two values, you need to use the OR function, not AND.

=COUNTIFS({Copy of Change Request Range 1}, OR(@cell = "Ronler Acres", @cell = "Ronler Acres/Portfolio"), {Copy of Change Request Range 9}, IFERROR(MONTH(@cell), 0) = 1, {Copy of Change Request Range 9}, IFERROR(YEAR(@cell), 0) = 2023))

This tells the COUNTIFS to look in the range {Copy of Change Request Range 1} for cells equal to either of those values.

All comments

Jeff Reisman

@Nkeiruka. Aguocha If you want to look for rows that contain either of two values, you need to use the OR function, not AND.

This tells the COUNTIFS to look in the range {Copy of Change Request Range 1} for cells equal to either of those values.

Nkeiruka. Aguocha

Hi @Jeff Reisman ,

That worked! Thanks for your help!!

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.