| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct not working
Read through many post. This seems to be the one I need but it is failing me.
I keep getting a sum of 0. It will work if remove all but one criteria, anymore I get sum 0. The sum should be 6 Occurrences.................. "Wc"=2 "S"=2 "L"=1 "V"=1 What am I doing wrong? =SUMPRODUCT(--(C4:AG4="S"),--(C4:AG4="L"),--(C4:AG4="V"),--(C4:AG4="WC")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct not working | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
| Sumproduct w/date criteria not working | Excel Worksheet Functions | |||
| SUMPRODUCT and format problems (2) | Excel Discussion (Misc queries) | |||
| Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
Threaded Mode
