add dynamic dates to my countif formula

[jdb2313]

I am trying to modify my countif statement. I like to enter a start(a1) and end date(b2) to have my formula filter and count only the date range. is this possible? any help would be appreciated.[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]


=COUNTIFS(E2:E100,"Apples",G2:G100, "Accepted")[/FONT]

 

[Fluff]

Which column contains the date?

 

[jdb2313]

Columh H

 

[Fluff]

How about

=COUNTIFS(E2:E100,"Apples",G2:G100, "Accepted",H2:H100,">="&B1,H2:H100,"<="&B2)

 

[jdb2313]

Perfect....Thank you so much for you help

 

[Fluff]

Glad to help & thanks for the feedback