Sales summary

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!
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
This might help do a summation using criteria. It looks up the salemen's names in the Sales List and summarises each saleman's sales in the Sales Summary table.

Move the Sales Summary to any other worksheet you desire.


Excel 2012
ABCD
1Sales List
2SalesmanSales
3Thomas48000
4Alice12500
5Bob394
6Thomas1200
7Alice4000
8Bob30000
9
10Sales Summary
11SalesmanSales
12Alice16500
13Bob30394
14Thomas49200
Sheet45
Cell Formulas
RangeFormula
D12=SUMPRODUCT(--(C12=$A$3:$A$8),$B$3:$B$8)
D13=SUMPRODUCT(--(C13=$A$3:$A$8),$B$3:$B$8)
D14=SUMPRODUCT(--(C14=$A$3:$A$8),$B$3:$B$8)
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top