| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Issue with sumproduct
Hello from Steved
Below is fine for D4:D109 but if I change it to D4:G109 it shows #VALUE! My objective is to sum the extra 3 columns. What is required please to have it working. =SUMPRODUCT(--('Planned Kilometres'!$A$4:$A$109=1),--('Planned Kilometres'!$B$4:$B$109="P"),'Planned Kilometres'!D4:D109) Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT issue | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
