Sum by Order

[Ofina]

I have a listing in Excel of items on orders with the prices per item. How can I sum the spreadsheet so that I get one total per order summing the extended prices of the items?

I can import into Access and do it there, but would prefer avoiding that step.

 

[SkipVought]

Hi,

Use a running sum like this in column Z, for instance, assuming that your item is in column A...
[tt]
Z2: =if(a2<>a1,1,z1+1)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

Or, perhaps you are looking for:
=IF(A2<>A1,SUMIF($A$1:$A$400,A1,$Z$1:$Z$400),"")

assuming you have 400 rows

A man has only two choices: He can be right or he can be happy.

 

[SkipVought]

Duh! Mine was just a running count.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

...its what Counts did during the French Revolution. < 1/2 grin>

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

or, if item in A and column to sum in B...
[tt]
Z2: =SUMIF($A$2:A2,A2,$B$2:B2)
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

A man has only two choices: He can be right or he can be happy.

 

[xlbo]

or whack a pivot table over the top of it and sum value by order number

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question