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

Try


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



--
Regards,

Peo Sjoblom



"Gary" <(E-Mail Removed)> wrote in message
news:36CDE8A5-2CB9-4EB9-A7DB-(E-Mail Removed)...
>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
>

try:

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

..... where is column B in the formula?

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

Better to put parameters in cells:

e.g. G1=Date
G2=Location
G3=Distance

=SUMPRODUCT(($A$3:$A$286=G1)*($B$3:$B$286=G2)*($C$3:$C$286<=G3))

HTH






"Gary" wrote:

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