| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals dependent on clumps of years
My data looks like so (excerpted, I've got about 600 rows of data or more):
01 2005 106108 200000 0.2 01 2008 106108 150000 0.2 01 2009 106108 390000 0.4 01 2009 106108 5750000 5.8 01 2007 109956 40000 0.0 01 2008 109956 150000 0.2 01 2008 109956 60000 0.1 What I'd like to do is have two subtotals for each PIN (PINs are in column C). One subtotal would be the sum of Column E if the year = 2005 to 2009 (including 2005 and 2009, column B). The other subtotal would be for the sum of Column E for years =2010. The columns are already sorted ascending by column A, then by column C then by column B. What would be the best way of going about this? Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D | Excel Worksheet Functions | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Convert years to years and days | Excel Discussion (Misc queries) | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
Threaded Mode
