Countif with Conditions

G

Gary

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
 
T

Toppers

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
 
Top