| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT PROBLEM
Assistance much appreciated
My worksheet as follows col A col B col C col D col E Name Club Age Group Place Points Fred aaa 16 1 5 Harry bbb 25 2 4 Col E is a result of =IF($D2=1,€5€, IF($D2=2,€4€, IF($D2=3,€3€, IF($D2=4,€2€, IF($D2=5,€1€,€€))))) Using =SUMPRODUCT(--($B$2:$B$25=€aaa€)*($E$2:$E25)) in H5 I get a #Value# error if any cell in col E is blank within the range. Need to sum by club the total number of points. My range would include people with no placing leaving the result in col E blank. Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem using ADDRESS() in SUMPRODUCT() | Excel Discussion (Misc queries) | |||
| Frustrating SUMPRODUCT problem. | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| SUMPRODUCT problem | Excel Worksheet Functions | |||
Threaded Mode
