| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP ON SUMPRODUCT() FUNCTION
Hi,
=SUMPRODUCT(--(DecMaxKms($B26-1)),--(DecMaxKms<=($C26)),--(DecTruckModel(D$23-1)),--(DecTruckModel<=(D$24)),INDIRECT("DEC"&$B$23)) I have ranges to find sum (sum ranges like DecHire ab8:ab19478, DecSpecial ac8:ac19478, and so on..). At the same time I have a range name DecAll with range ab8:af19478, to get sum of all columns with given condition, there I get error as "Value#". Can You all help me out ? many thanks in advance. When I just put = sumproduct(decall) - it is giving result, but with condition like above it is throwing error. Am I expecting more or I have done some error, please help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| sumproduct function / VB user defined function | Excel Discussion (Misc queries) | |||
| Is SUMPRODUCT the right function to use? | Excel Worksheet Functions | |||
| Help on sumproduct function | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
Threaded Mode
