Monthly counting of check boxes or items

Stevefc

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  

Paul Newcome

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)

Paul Newcome

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

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

Stevefc

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

Paul Newcome

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)

Stevefc

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

Paul Newcome

Happy to help! 👍️