Adding a date range to COUNTIFS

Nat

Hello,

I need to add a date range to a rollup I created for tracking sales meetings:

=COUNTIFS({source sheet customer name}, $[Primary Column]@row, {source sheet dropdown result}, [In Person Meeting]$1)

The above works, but is obviously counting the whole sheet, which includes 2 years of data.

I tried:

=COUNTIFS({source sheet customer name range}, $[Primary Column]@row, {source sheet dropdown range}, [In Person Meeting]$1, {source sheet date range}, >23 / 4 / 1 < 24 / 3 / 31)

but that gives me the answer "0" for all of them.

If anyone could help I'd appreciate it!

Paul Newcome

When referencing a date in a formula, you have to use a DATE function.

23 / 4 / 1

is basically saying 23 divided by 4 divided by 1.

Give this a try instead:

=COUNTIFS({source sheet customer name range}, $[Primary Column]@row, {source sheet dropdown range}, [In Person Meeting]$1, {source sheet date range}, AND(@cell> DATE(2023, 04, 01), @cell< DATE(2024, 03, 31)))