Combine and Total sales data into new sheet

**kelemvor** · 07-18-2011, 02:34 PM

I don't think this woudl be very hard but am not sure where to start.

Basically I have a list of orders that contains one line item for each item ordered. SO one order might have 5 rows if they ordered 5 items.

What I want to do is jsut get a total for every order and have it on its own line.

So if the data was something like

Order    Item    Price
1        1234    10
1        1235    11
2        1236    15
2        1237    20

What I'd want to get back would be:

Order    Total
1        21
2        35

Thanks for any help.

**JBeaucaire** · 07-18-2011, 02:55 PM

Not really a programming question.

1) Use the ADVANCED FILTER on column A to give you a list of the unique order numbers in a new column, say column G.

2) Put a SUMIF() formula in H2, like so, then copy down:

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

=======

Or highlight all the data and apply a Pivot Table to get a sum of the Order Numbers.