jmm2
01-09-2009, 07:46 AM
Hi All,
I was wondering if it were possible to develop a subtotal formula that will be able to determine the range in which to subtotal based on dates in a separate cell. If you see below for example, is there a formula I could possibly drag down column three that will tell the sheet to populate the subtotal of the transactions in the second column based on the date in the first column in place of the 'SUBTOTAL' cell. The problem im having is that the file is quite large (15,000+ rows) and there are about 90 spreadsheet I would be using this formula for. Any help is appreciated!
1/1/2009| 4561
1/1/2009| 6635
1/1/2009| 65364
1/1/2009| 36
1/1/2009| 364
1/1/2009| 3671
1/1/2009| 2796
1/1/2009| 5636| SUBTOTAL
1/2/2009| 2345
1/2/2009| 954
1/2/2009| 2365
1/2/2009| 4316| SUBTOTAL
1/3/2009| 423
1/3/2009| 16853| SUBTOTAL
1/4/2009| 4653
1/4/2008| 12
1/4/2007| 865
1/4/2006| 7556
1/4/2005| 4005| SUBTOTAL
I was wondering if it were possible to develop a subtotal formula that will be able to determine the range in which to subtotal based on dates in a separate cell. If you see below for example, is there a formula I could possibly drag down column three that will tell the sheet to populate the subtotal of the transactions in the second column based on the date in the first column in place of the 'SUBTOTAL' cell. The problem im having is that the file is quite large (15,000+ rows) and there are about 90 spreadsheet I would be using this formula for. Any help is appreciated!
1/1/2009| 4561
1/1/2009| 6635
1/1/2009| 65364
1/1/2009| 36
1/1/2009| 364
1/1/2009| 3671
1/1/2009| 2796
1/1/2009| 5636| SUBTOTAL
1/2/2009| 2345
1/2/2009| 954
1/2/2009| 2365
1/2/2009| 4316| SUBTOTAL
1/3/2009| 423
1/3/2009| 16853| SUBTOTAL
1/4/2009| 4653
1/4/2008| 12
1/4/2007| 865
1/4/2006| 7556
1/4/2005| 4005| SUBTOTAL