First, results in E will be text not numbers as a result of your formula -
removw "" arounf results

=IF($D2=1,5, IF($D2=2,4, IF($D2=3,3, IF($D2=4,2, IF($D2=5,1€�€�€�)))))

which can be simplified to

=6-D2

Or

=if(D2="","",6-D2)

SUMPRODUCTworks OK or you could try

=SUMIF(B2:B25,"aaa",E2:E25)

HTH

"laurie g" wrote:

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