PDA

View Full Version : Quick Subtotal Question



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

Bob Phillips
01-09-2009, 07:57 AM
C1: =MONTH(A1)

copy down, and break on column C in the subtotal.

Or if not using SUBTOTAL, try

=IF(A1=A2,"",SUMIF(A:A,A1,B:B))