Count matching instances between a date range then multiply answer by another cell

[JustyR]

Hi, all,

I'm trying to countif using exact criteria.

A B C
08/08/2017 • x
15/08/2017 • x
22/08/2017 x •
29/08/2017 • x

Year 1
08/08/2017
07/08/2018

I want to count the number of bullets (•) from columns B and C, BUT only when they fall within the date range specified in A7:A8.

Is that possible? Just not finding anything online.

Many, many thanks if you can help. It's driving me nuts.

Edit: the subject is a little misleading as I don't need the resulting value multiplied by another cell....yet!

 

[JustyR]

All done

=SUMPRODUCT((Dates!$B$6:$F$999="•")*(Dates!$A$6:$A$999>=A6)*(Dates!$A$6:$A$999<=A7))