sum by range in previous cell

[vkrstic]

i have a table:
2007 2006 2005
1.jan 200 254 547
2.jan 125 200 214
3.jan 50 154 324
4.jan 144 214
5.jan 254 214
6.jan 148 200

i want to make a sum:
2007 =sum january 2007
2006 =sum 2006 by last day entry in
january2007
2005 =sum 2005 by last day entry in january2007

Can anyone help me ?
Thank you
Vladan

 

[vkrstic]

I forgot to say that i am entering values every day in column A, so i
have to make expresion in 2006 and 2005 that will take into acount sum
of range in column A. Sum in 2005 and 2006 have to be changed
automaticly when I enter value in 2007
thank you


(e-mail address removed) је напиÑао