Sum a amount until the current month

[pfb93]

Hey everyone,

I am struggeling with a thing which i think is very basic. I got the following table:

Account	January	February	March	…	December	AmountToToday
1	200 €	30 €	50 €	…	10 €	280 €

Suppose the current month is march, then i want the last column (AmountToToday) to calculate the sum of january, february and march. The calculation should always display the sum of the months until the current month of the year.

Thanks!

[MK9885]

Maybe

Sum({ < Month = {"<=$(=num(Month))"}, Year,Month ,Year = {$(=Max(Year))}   >}  AmountToToday)