Countifs Formula using a date range given

Karina.Perez

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. 

Paul Newcome

Give this a go...

 

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