# Excel sum by date on growing column

March 15, 2011 at 04:00:15
Specs: Macintosh
 HI, I hope someone can help me here. I have a table. Column A is a month (numeric), Col B is year (numeric), Col C is a monetary value. For each month there are a variable number of entries, so the table would look something like below (shortened example - each month normally has about 70 to 80 entries:A B C1 2010 35.991 2010 27.991 2010 15.992 2010 12.992 2010 45.993 2010 33.993 2010 23.993 2010 56.99Each month, new data is added so the columns keep extending.OK, to the right of this table, I sum each month, i use K,L,M columns for thisK contains the calculation, L the month, M the YearK L Msumifs 1 2010sumifs 2 2010sumifs 3 2010I am using SUMIFS at the moment, as follows:K1 = SUMIFS(\$C\$2:\$C\$2000,\$A\$2:\$A\$2000,L2,\$B\$2:\$B\$2000,M2)K2 = SUMIFS(\$C\$2:\$C\$2000,\$A\$2:\$A\$2000,L3,\$B\$2:\$B\$2000,M3)This does work, but I continually have to adjust the "2000" in the example to be the full length of the columns as they continues to grow as i add new data for new motnhsI am sure there is a "proper" way to do this, but I just don;t know how. Any help would be very much appreciated.

See More: Excel sum by date on growing column

#1
March 15, 2011 at 07:55:08
 Use just the column as a reference. Example A:AI'm still learning everyday.

Report •

#2
March 15, 2011 at 08:33:58
 Of course! So obvious yet i didn't see it. Thank you.

Report •

Related Solutions