Transaction Summary

Hi,

I have some sales data (multiple transactions under a few names) I'd like to have a summary to the right of the data which lists total sales for under each person's name.

In the example, Samie has 3 transactions totalling £2,182 and I'd like to show that automatically.

Any thoughts of a simple way to accomplish this?

Sales Summary Example .xlsx

Hi, does your data keep updating or static?



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Thanks Olly, don't know why I didn't try the Pivot table before! Your formula also worked well, thank you.