SUMIF [sum_range] select different columns

Hi to everyone!

First of all, thank you for your help!

I have been struggling with a SUMIF formula (SUMAR.SI in Spanish)

As you know, the syntax of the formula is SUMIF(range, criteria, [sum_range])

I would like to change the [sum_range] column depending on a formula.

The data I want to obtain the info from is organiced like this (by products):

The columns, as you can see, are the different months.

Depending on which week (semana) of the year I’m preparing the report, I want to SUMIF from that specific month.

Per example,

If I want to SUMIF the budget “Presupuesto” of September “sep” I would write: SUMAR.SI(A:A;”Presupuesto”;D:D)

If I want to SUMIF the budget “Presupuesto” of December “dic” I would write: SUMAR.SI(A:A;”Presupuesto”;G:G)

The problem is that I don’t want to have to write the last argument of the formula, I want it to be given from a cell that contains another formula (that VLOOKS up from a table that contains the different weeks of the year)

So, my question is…

Is it possible to write the SUMIF formula obtaining the [sum_range] from another specific cell that contains a formula?

Thanks again,

Angela.