# Sales summary

#### phantomrogue

##### New Member
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
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)

#### phantomrogue

##### New Member
Works an absolute treat! Many, many thanks for this!

#### DRSteele

##### Well-known Member

Replies
3
Views
303
Replies
1
Views
3K
Replies
4
Views
388
Replies
0
Views
1K
Replies
11
Views
738

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.

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.

### Which adblocker are you using?

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

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