| 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 | |||
Hybrid Mode
