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

• ✭✭✭✭✭✭

@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.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭

@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.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• That worked! Thanks for your help!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!