Sum Question

G

Guest

I have data similar to the following:

Client Unit Sales
ABC Company 1 1000
ABC Company 2 1500
ABC Company 3 2000
LMN Company 150 5000
LMN Company 151 3000
LMN Company 152 2000
LMN Company 153 6000
LMN Company 154 7000
XYZ Company 80 10000
XYZ Company 81 15000
XYZ Company 82 12000

I would like to add a column in column D which would give me the following:

Client Unit Sales Tot. Sales By Client
ABC Company 1 1000 4500
ABC Company 2 1500 4500
ABC Company 3 2000 4500
LMN Company 150 5000 23000
LMN Company 151 3000 23000
LMN Company 152 2000 23000
LMN Company 153 6000 23000
LMN Company 154 7000 23000
XYZ Company 80 10000 37000
XYZ Company 81 15000 37000
XYZ Company 82 12000 37000

As you can see, column D would look to the client name and sum up the total unit sales for each individual client. I realize I could get similar results using a pivot table, however, I need to be able to show the total sales in column D as well as show the individual unit sales at the same time (as above). Anyone got any suggestions on a formula that may work for this. Any help greatly appreciated. Thanks.

Ron
 
D

Dan E

Ron,

Formula for column D

=SUMIF(A:A,A2,C:C)

Dan E

Ron said:
I have data similar to the following:

Client Unit Sales
ABC Company 1 1000
ABC Company 2 1500
ABC Company 3 2000
LMN Company 150 5000
LMN Company 151 3000
LMN Company 152 2000
LMN Company 153 6000
LMN Company 154 7000
XYZ Company 80 10000
XYZ Company 81 15000
XYZ Company 82 12000

I would like to add a column in column D which would give me the following:

Client Unit Sales Tot. Sales By Client
ABC Company 1 1000 4500
ABC Company 2 1500 4500
ABC Company 3 2000 4500
LMN Company 150 5000 23000
LMN Company 151 3000 23000
LMN Company 152 2000 23000
LMN Company 153 6000 23000
LMN Company 154 7000 23000
XYZ Company 80 10000 37000
XYZ Company 81 15000 37000
XYZ Company 82 12000 37000

As you can see, column D would look to the client name and sum up the total unit sales for each individual client. I realize I
could get similar results using a pivot table, however, I need to be able to show the total sales in column D as well as show the
individual unit sales at the same time (as above). Anyone got any suggestions on a formula that may work for this. Any help
greatly appreciated. Thanks.
 
B

Bob Phillips

Ron,

Put this formula in D2

=SUMIF($A$1:$A$5,$A1,$C$1:$C$5)

and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Ron said:
I have data similar to the following:

Client Unit Sales
ABC Company 1 1000
ABC Company 2 1500
ABC Company 3 2000
LMN Company 150 5000
LMN Company 151 3000
LMN Company 152 2000
LMN Company 153 6000
LMN Company 154 7000
XYZ Company 80 10000
XYZ Company 81 15000
XYZ Company 82 12000

I would like to add a column in column D which would give me the following:

Client Unit Sales Tot. Sales By Client
ABC Company 1 1000 4500
ABC Company 2 1500 4500
ABC Company 3 2000 4500
LMN Company 150 5000 23000
LMN Company 151 3000 23000
LMN Company 152 2000 23000
LMN Company 153 6000 23000
LMN Company 154 7000 23000
XYZ Company 80 10000 37000
XYZ Company 81 15000 37000
XYZ Company 82 12000 37000

As you can see, column D would look to the client name and sum up the
total unit sales for each individual client. I realize I could get similar
results using a pivot table, however, I need to be able to show the total
sales in column D as well as show the individual unit sales at the same time
(as above). Anyone got any suggestions on a formula that may work for this.
Any help greatly appreciated. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top