Adding a date range to COUNTIFS

Nat
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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!