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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,484
Office Version
  1. 365
Platform
  1. Windows
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)
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,484
Office Version
  1. 365
Platform
  1. Windows
Super! I'm glad I helped.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,409
Messages
5,831,448
Members
430,069
Latest member
bubbleboom

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
Top