Sum of individual data in column A for each unique cell

[lindafinlay]

Hi,

I am sure there must be a simple way to do this, but I cannot find a formula to suit. I have a spreadsheet that lists invoice numbers in Column A. Column I contains the cost of each item for that invoice. What I need is to get excel to automatically find the same invoice numbers in column A and add up a total using the costs in Column I. In my attached example I have manually done what I need the formula to do in column L. Is this possible? Or is there a better way of doing this?

Cheers,

Linda

[RHCPgergo]

Hi,

a pivot table is what you need. (At least that's how I would do it.) Have a look at the example.

[:) Sixthsense :)]

In L2 cell

Please Login or Register  to view this content.

Drag it down...

For your understanding

The below formula will get the sum of that particular invoice

Please Login or Register  to view this content.

The below formula will confirm whether it is last entry

Please Login or Register  to view this content.

Mingled both formula's and shown in initial suggestion

[nacholimon]

You could use the following formula on L2

Please Login or Register  to view this content.

[lindafinlay]

Thanks SixthSense! Perfect - just what I wanted!
And I had considered a pivot table RHCPgergo but really wanted all the info easily viewed on 1 spreadsheet.

Thanks guys!!