Sheet Summary - Counting number of submissions between two dates in a column

Rachael Stammers

Using the Sheet Summary option, I would like to count the number of reports submitted each month. The formula I am using does not work

=COUNTIF([Event Occurrence Date]:[Event Occurrence Date], >=DATE(2021, 1, 1), <=DATE(2021, 1, 31))

I was able to count this information using a formula in another grid/sheet by using the following formula

=COUNTIFS({Aviation Safety Reports Range 1}, >=DATE(2021, 1, 1), {Aviation Safety Reports Range 1}, <=DATE(2021, 1, 31))

(where Aviation Safety Reports Range 1 refers to the column titled Event Occurrence date).

What am I doing wrong with the Sheet Summary formula to get the message Incorrect Argument Set?

All help gratefully appreciated

Paul Newcome

You would have to repeat the range for the second criteria set the same way you did with the second formula (and use a COUNTIFS with the "S" on the end).

First formula:

=COUNTIF(range, criteria, criteria)

Second formula:

=COUNTIFS(range, criteria, range, criteria)

Paul Newcome

Happy to help. 👍️

Paul Newcome

You would have to repeat the range for the second criteria set the same way you did with the second formula (and use a COUNTIFS with the "S" on the end).

First formula:

=COUNTIF(range, criteria, criteria)

Second formula:

=COUNTIFS(range, criteria, range, criteria)

Rachael Stammers

Thank you Paul,

That worked! I thought I'd done that previously and got an error message, but maybe I hadn't!

Paul Newcome

Happy to help. 👍️