| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
total sum of objects with the same name
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Threaded Mode
