Formula to count both names in one column for year 2023

Nkeiruka. Aguocha

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))

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.

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.

Nkeiruka. Aguocha

Hi @Jeff Reisman ,

That worked! Thanks for your help!!