Formula to count both names in one column for year 2023

Options

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

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    @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

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!