I would like to know if it is possible to count by Color...I have seen several posts that this can be done.

I would like to have this done within a given date range....

Here is the basic formula I am using....to get the total count within my defined date range.

=SUMPRODUCT(($D$8:$D$999>=$F$2)*($D$8:$D$999<=$F$3 ))

Any help on this is greatly appreciated