Countif with Conditions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary - 12 Jun 2007 20:04 GMT

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

Reply to this Message

Peo Sjoblom - 12 Jun 2007 20:05 GMT

Try

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

Signature

Regards,

Peo Sjoblom

>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,
[quoted text clipped - 7 lines]
>
> Gary

Reply to this Message

Toppers - 12 Jun 2007 20:10 GMT

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

> 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
[quoted text clipped - 6 lines]
>
> Gary

Reply to this Message