COUNT CELLS BY MONTH WITHIN ONE RANGE (COUNTIFS?)

Dan Benitah
Dan Benitah โœญโœญโœญ

Hello Everyone!

First time asking for help, I always found my answers within everyone else's questions, but not this time!

We work off one main sheet where all our leads come in, I would like to create in another sheet a count by month of that "created date" column, to see how many leads came in in January, in February, March...


Screen Shot 2023-06-28 at 8.35.55 AM.png Screen Shot 2023-06-28 at 8.36.07 AM.png

What should be the formula to get my total by month?

I tried several ones but can't figure it out...


Thank you!!

Best Answer

  • Nick Korna
    Nick Korna Community Champion
    edited 06/28/23 Answer โœ“

    The formula from @Paul Newcome should work, though the below would be an alternative:

    =COUNTIFS({Date created Range 1}, AND(IFERROR(YEAR(@cell), 0) = YEAR([Start Date]@row), IFERROR(MONTH(@cell), 0) = MONTH([Start Date]@row)))

    Either of these should work.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!