Originally Posted by Iggawalla

Hello,

I am trying to create a spreadsheet that will contain information regarding vehicles and the price in which I sold them for.

e.g.

Column A: Make
Column B: Model
Column C: VIN
Column D: Purchase Date
Column E: Sold Date
Column F: Sold Price

Because there are many different makes and models, I want to be able to sum up the values (Column F) of all the 'Civic' (Column B) that I might have in the table. The table will have anywhere from 50-120 vehicles in a monthly spreadsheet. Different makes and models being sold each day so the data initially wont be in order. It would be nice to have a formula that sums it up as I enter it so I have this information available to me on a daily basis...

Can this be done?

Thanks,

Danielle