Countifs Formula using a date range given

Karina.Perez ✭✭✭
edited 12/09/19 in Formulas and Functions

I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date.

I need to limit the data count on the metric sheet to only count if is it in between (and including) start and end dates given at any time. 

=COUNTIFS({Score}, "Pass", {Club}, "AAA ACG - AAA Chicago", {Class}, "Battery 101", ({Date} <> [Start Date]1:[End Date]1))

How do I end the formula so that it only counts data within the start and end dates given. This start and end date fields are on the metrics sheet. 

Date range capture.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!