counting Total £££ for customers that can appear more then once

Hello

I have the following sheet, each time a customer buys a savings product they are put onto the list, the same customer can appear as many times as they like on the list is they buy more than once, buys product on 1st of april then another product on the 2nd of april they appear 2ce on the sheet.

I have done the forumla to sum the amount of times they appear on the sheet ( total number of sales ) but I need to work out the total comission per person.

Hope its clear on the attached sheet it has comments to help make clear

Thanks

Use Sumif()

e.g.

=SUMIF(Post_Code,Post_Code,L:L)

you can name the L:L range too.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save