# Monthly counting of check boxes or items

Options
✭✭

I need to produce a monthly report on how often a type of work is booked on a support project. For the report I need to have a month on month summary. Is it possible count against a specific date range e.g. April. May etc? Regards Steve

• ✭✭✭✭✭✭
Options

Using the COUNTIFS, you would follow the pattern of range, criteria, range, criteria, etc.....

=COUNTIFS([Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = ##, IFERROR(YEAR(@cell), 0) = ####), [Checkbox Column]:[Checkbox Column], 1)

• ✭✭✭✭✭✭
Options

Yes. It would look something along the lines of...

=COUNTIFS([Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = ##, IFERROR(YEAR(@cell), 0) = ####))

• ✭✭
Options

Hi Paul, thanks for your reply. I can see how this works, thank you. How can I count the check boxes within a selected date range, do I combine the correct formula with a check box count?  Regards Steve

• ✭✭✭✭✭✭
Options

Using the COUNTIFS, you would follow the pattern of range, criteria, range, criteria, etc.....

=COUNTIFS([Date Column]:[Date Column], AND(IFERROR(MONTH(@cell), 0) = ##, IFERROR(YEAR(@cell), 0) = ####), [Checkbox Column]:[Checkbox Column], 1)

• ✭✭
Options

Hi Paul, that works well, thank you, regards Steve

• ✭✭✭✭✭✭
Options

Happy to help! 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!