COUNTIF to determine the number of tickets created in a given month.

Andres Valdivieso

Hello,

I am trying to figure how many tickets have been created by month using the formula below, but getting unparseable result.

Any help is much appreciated.

=COUNTIFS([Created Date]1:[Created Date]300, AND(@cell >= DATE(2020, 5, 1), @cell <= DATE(2020, 5, 31)))

Thank you,

John Jonassen

Try this:

=COUNTIFS([Created Date]:[Created Date], >=DATE(2020, 5, 1), [Created Date]:[Created Date], <=DATE(2020, 5, 31))

Tana Rucker

Another solve could include the pivot app.

John Jonassen

Try this:

=COUNTIFS([Created Date]:[Created Date], >=DATE(2020, 5, 1), [Created Date]:[Created Date], <=DATE(2020, 5, 31))

Andres Valdivieso

Thank you @JohnJonassen, this worked perfectly.

Tana Rucker

Another solve could include the pivot app.