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:

1 2010 35.99
1 2010 27.99
1 2010 15.99
2 2010 12.99
2 2010 45.99
3 2010 33.99
3 2010 23.99
3 2010 56.99

Each 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 this
K contains the calculation, L the month, M the Year

sumifs 1 2010
sumifs 2 2010
sumifs 3 2010

I 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 motnhs

I 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

Report •

March 15, 2011 at 07:55:08
Use just the column as a reference. Example A:A

I'm still learning everyday.

Report •

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

Report •

Related Solutions

Ask Question