Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Logical Function
Can anyone tell me what is wrong with this function? I've switched from
Excel 2000 to 2003. - it used to work, but doesn't now. =SUMPRODUCT(--(E6:E500=W24),(--(T6:T500="1"))) Trying to calculate how many have two existing conditions ALSO how many if there are three existing conditions. -- B. Davis |
#2
|
|||
|
|||
Are the values in T6:T500 text? If not remove the qoutations around 1 in your
criteria Regards, Peo Sjoblom "brandyda" wrote: Can anyone tell me what is wrong with this function? I've switched from Excel 2000 to 2003. - it used to work, but doesn't now. =SUMPRODUCT(--(E6:E500=W24),(--(T6:T500="1"))) Trying to calculate how many have two existing conditions ALSO how many if there are three existing conditions. -- B. Davis |
#3
|
|||
|
|||
T is a number as text
E is an age developed by a formula F is text G is text -- B. Davis "Peo Sjoblom" wrote: Are the values in T6:T500 text? If not remove the qoutations around 1 in your criteria Regards, Peo Sjoblom "brandyda" wrote: Can anyone tell me what is wrong with this function? I've switched from Excel 2000 to 2003. - it used to work, but doesn't now. =SUMPRODUCT(--(E6:E500=W24),(--(T6:T500="1"))) Trying to calculate how many have two existing conditions ALSO how many if there are three existing conditions. -- B. Davis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Logical AND function | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
using logical functions as criteria with the SUMIF function | Excel Worksheet Functions |