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

Dear Danielle, Good Morning

Try this kind of process:

=SUMPRODUCT((B1:B200="Civic")*(F1:F200)*(E1:E200<= TODAY()))

I hope it can help you.

__________________________
Minas Gerais, Brasil
Mazzaropi

If it's ONLY for models:
=SUMIF(Column B, "Civic", Column F)

If it's ONLY for makes:
=SUMIF(Column A, Make, Column F)

If it's BOTH model and make
=SUMIFS(Column F, Column A, Make, Column F, Column B, Models)