I need assistance with a formula that will count locations within a certain
radius on a certain date. Column A is the date, Column B is a location, and
Column C is miles away. The current formula which is not yielding any
results is as follows:

=SUMPRODUCT(($A$3:$A$286="4/3/2007")*($C$3:$C$286<=5))


Thanks,

Gary