| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What wrong with sumproduct function?
I would like to sum all numbers, which match following conditions,
=SUMPRODUCT(($B$1816:$B$2400=$A2402),(C$1816:C$240 0<0),(C$1816:C$2400)) press ctrl + shift + enter but it returns zero, and I have checked it, zero should not be the result. Does anyone have any suggestions what wrong with sumproduct function? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| What's wrong with this IF function. | Excel Discussion (Misc queries) | |||
| What is Wrong with this function?????????? | Excel Worksheet Functions | |||
| What am I doing wrong with PMT function? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT is showing wrong Amount | Excel Discussion (Misc queries) | |||
Threaded Mode
