G
Guest
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
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