Switching collumn in "Sum" Formula based on current date / month

Hello everyone,

I created a table with KPI's for each month and wanted to have a collumn for the YTD status, so i can see how good we are doing as of right now.

But for that I need the formula to switch the collumn and add the values of the current month to the existing one.

I have to rows for each month: the planned value and the actual one. The later is easy to sum up because I am only adding data as the month is completed.
The other one is tricky because i have planned values for each month of the year ahead.

I need a way to have a "SUM" Formula that for example changes from 11/30 to October First automatically and adds the Oktober Data.
I have marked the affected cells in yellow. The collumn that says "kumuliert" is the one registrating the YTD value.

I dont know if I explained it good enough but if you have questions, fell free to ask them.


Greetings Lucien

In Q9:

=SUMIF(D10:P10,"<>",D9:P9)

Copy down to other planned rows.

See attached for how it should be in your locale.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.