COUNTIF needed based on date ranges entered into cells

[excelteam777]

WS attached
I need a countif formula based on date ranges entered.
Formula goes into D6
Start Date Range: F1 , Stop Date Range: F2

When an item type is entered into D5, say “Apple”,
I need a count of that particular item from the range of D9:D18,
based on the dates entered in E9:E18, that fall between a date range entered into F1-F2.

[FlameRetired]

Please try

Please Login or Register  to view this content.

You may find this link helpful.

[protonLeah]

=countifs($d$9:$d$18,$d$5,$e$9:$e$18,">="&$f$1,$e$9:$e$18,"<="&$f$2)