Summarizing problem 1

[Audissimo]

Hi!

I have a problem. This should be a easy one, but for some reason, I just don't get a glue.

Well, I have a sheet where I have a few columns full of data. In the first column (col A) I have an ID code and the next one (col B) I have a price for it. The ID code can be occured several times and the price can be different at ecah time.

Now I need to copy the Id code into a column C and the column D I need a total amounts of times when this ID code occures and into a column E I need a total price for this ID codes. And when the ID code changes, a procedure descibed above starts again as long as column a has the ID codes.

Example:
ID Codes Price ID code Pcs Total Price
1000 23,40 1000 6 142,95
1000 22,30 1001 3 32,50
1000 21,50 1002 1 50,02
1000 25,50 2334 2 26,84
1000 23,00
1000 27,25
1001 10,00
1001 11,00
1001 11,50
1002 50,02
2334 12,34
2334 14,50

Can someone please give a some advice?

Br
-JK

 

[GlennUK]

Just make a pivottable from your data, they are perfect for summarising data tables.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.