Countif with Conditions
 

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

Countif with Conditions
 

Try


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



--
Regards,

Peo Sjoblom



"Gary" wrote in message
...
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

Countif with Conditions
 

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