COUNT CELLS BY MONTH WITHIN ONE RANGE (COUNTIFS?)

Options

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


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 ✭✭✭✭✭✭
    edited 06/28/23 Answer ✓
    Options

    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!