| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
I am attempting to use the sumproduct function to determine the number of
ovetime hours worked by week. The following formula is returning a zero value, which is incorrect: =SUMPRODUCT((D$2:D$15000="20051009")*(E$2:E$15000= "L102")*(I2,I15000)) Seems pretty straightforward, but it's not working. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
