Help: how to "merge" rows while summing some values

S

stevels70

Hi,

sorry for the title, but I have no simpler way to put it: here is the
issue:

I have a worksheet where different orders from the different customers
are shown. I would like to get a resulting sheet where I have only one
row for each customer, where the total $ amount is shown for each
customer.

Column A and B identify the customer (name and location), column C and
D are the $ amount and number of items.

So I have sorted the sheet using A and B: now I would like Excel to
uniquify the rows based on column A and B, while showing the total per
customer on column C and D

Any help is greatly appreciated

Regards,
Stefano
 
J

Joel

I would use an IF Function.
Put in Row 1 Column E
=D1

Put in Row 2 to the lastt Row in Column E
=IF(A1=A2,E1+D2,D2))
this will compare the customer in previous row with current row and get a
total for each customer
You can then put in Row 1 to the Last Row in Column F another If statement

=if(A1=A2,"",D1)
 
Top