COUNTIFS with Specific Dates

Jesse Willis

I'm working on a Pre-COVID and COVID list and could use some help. Can someone take a look?

One example: We need to COUNT how many times TRB was used during the dates of January 1st, 2020 to March 13, 2020.

=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), ([EventDate, >DATE(2020, 1, 1):EventDate, <DATE(2020, 3, 13)])

Mark Cronk

Hi @Jesse Willis ,

Try:

=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), [EventDate]:[eventdate], >DATE(2020, 1, 1), [EventDate]:[eventdate], <DATE(2020, 3, 13)])

Mark

Mark Cronk

Hi @Jesse Willis ,

Try:

=COUNTIFS(Division:Division, CONTAINS("TRB", @cell)), [EventDate]:[eventdate], >DATE(2020, 1, 1), [EventDate]:[eventdate], <DATE(2020, 3, 13)])

Mark

Jesse Willis

Thanks Mark!

I used the following that worked beautifully!

=COUNTIFS({Complex Virtual Meeting Support Request Range 1}, =Division@row, {Zoom Webinar -Report Range 1}, >=DATE(2020, 1, 1), {Zoom Webinar -Report Range 1}, <=DATE(2020, 3, 13))

Mark Cronk

Happy to help. Thank you for using the Community.

Be Well,

Mark