Sumproduct Formula

[Blake 7]

Dear Community,

Good evening,,,,,,,, slippers are on, fire is burning nicely, I have a nice freshly brewed cup of Betty's Tea, and a slice of cheese on toast with worcester sauce. Ummmmmm!

Time to hit the spreadsheets!!

Attached is a spreadsheet and I am having difficulty with sumproduct. I believe that would be the most efficient function for my needs. If not please feel free to let me know!

In cell F75 I would like the sumproduct of cell E75 (E75 is somewhere in Col E3;E58 it could appear once or twice or three times.....)

The figures I need summed appear in COL L3;58 labelled STARTS, COL M3;M58 labelled COMPLETING, COL N3;N58 labelled ACHIEVMENTS.

im sure it will make more sense once the spreadsheet is opened as i gave an example of the desired result.

Thanks guys. Have a good eve

[NBVC]

I think you need SUMIF:

=SUMIF($E$3:$E$58,$E75,L$3:L$58)

copied across the 3 columns and down the rows.

[Blake 7]

Hi N,

Worked a treat....... thank you for your time, kind of you.

Have a good evening

[NBVC]

Enjoy your tea