Adding a date range to COUNTIFS

Nat ✭✭✭✭✭


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!