Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CountIf with 2 conditions - help! | Excel Worksheet Functions | |||
COUNTIF for 2 conditions | Excel Worksheet Functions | |||
countif two conditions | Excel Discussion (Misc queries) | |||
COUNTIF with two conditions | Excel Worksheet Functions | |||
COUNTIF - 2 conditions | Excel Worksheet Functions |