| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct not working
Hi this is my formula
=SUMPRODUCT(--($F$3:$F$1500=(OR(5,6,7))),--($L$3:$L$15000),$M$3:$M$1500) but it returns zero value and i'm guessing its the OR function, but how can I work around this please? TIA Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
