| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMPRODUCT on multiple values
I attempted to use the multiple criteria as in:
=SUMPRODUCT(--(A1:A10={"Ford","Chrysler"})) but the result returns #VALUE! Also, assuming I can get this to work, does this also work for < (Not equal to)? So the formula would be: =SUMPRODUCT(--(A1:A10<{"Ford","Chrysler"})) |
|
#2
|
|||
|
|||
|
SUMPRODUCT on multiple values
here is one I have been using a long time. Works just fine
=-SUMPRODUCT((ChecksC={"electricity","water","sewer" ,"garbage"})*(ChecksD)) -- Don Guillett SalesAid Software "FrankTimJr" wrote in message ... I attempted to use the multiple criteria as in: =SUMPRODUCT(--(A1:A10={"Ford","Chrysler"})) but the result returns #VALUE! Also, assuming I can get this to work, does this also work for < (Not equal to)? So the formula would be: =SUMPRODUCT(--(A1:A10<{"Ford","Chrysler"})) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
| Formatting multiple values | Excel Discussion (Misc queries) | |||
| counting rows with same values for multiple values | New Users to Excel | |||
| Multiple lookup value's | Excel Worksheet Functions | |||
Linear Mode
