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 C

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.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 this

K contains the calculation, L the month, M the YearK L M

sumifs 1 2010

sumifs 2 2010

sumifs 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 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.

Use just the column as a reference. Example A:A I'm still learning everyday.

Of course! So obvious yet i didn't see it. Thank you.

Ask Your Question

Weekly Poll

Do you think state sales tax should be charged on Internet purchases?

Discuss in The Lounge

Poll History