phantomrogue
New Member
- Joined
- Jun 18, 2015
- Messages
- 2
Hi, was wondering if someone could please solve this problem for me? I have an Excel file with a worksheet called 'Data' detailing sales people and sales figures against each one.
Thomas 48000
Alice 12500
Bob 394
Thomas 1200
Alice 4000
Bob 30000
Now, in a separate sheet called 'Summary' I need to list total sales from all the sales people.
I.E.
Thomas 49200
Alice 16500
Bob 30394
This needs to dynamically update as sales are added to the 'Data' sheet. I am fairly new to Excel, so any help would be very much appreciated.
Thank you!
Thomas 48000
Alice 12500
Bob 394
Thomas 1200
Alice 4000
Bob 30000
Now, in a separate sheet called 'Summary' I need to list total sales from all the sales people.
I.E.
Thomas 49200
Alice 16500
Bob 30394
This needs to dynamically update as sales are added to the 'Data' sheet. I am fairly new to Excel, so any help would be very much appreciated.
Thank you!