Excel Formula Question

[spongebob80]

I have data similar to this:

Make Model Qty
Ford Fusion 25
Honda Accord 13
Honda Accord 17
Ford Fusion 18

I want the output to be:
Ford Fusion 43
Honda Accord 30

I know this can be done with 2 conditional sums, but in my real problem I have 1500 vales in column A and 30+ in column B.

Is there a way to do this in Excel or am going to have to write a program (if that's the case, any idea)?

Thanks

[Mikeopolo]

I suggest investigating pivot tables, they will summarise on multiple (row) values)

Note that you cannot have blank cells in the data source

Regards
Mike

[JBeaucaire]

This is one of my standard formulas...compare columns A and B, consolidate data in column C. Give it a try.

Please Login or Register  to view this content.

[shg]

Welcome to the forum, spongebob.

Please take a few minutes to read the forum rules about thread titles, and then amend yours accordingly.