Formula solution without VBA

[rdw72777]

I have the following formula:

=SUMIF(Master!$A:$A,$A10&"_Y",Jan_BUD)

"JAN_BUD" is a named range, and there are also named ranges for "FEB_BUD", "MAR_BUD" and so on.

Each month the month name ("Jan") will change depending on the value in the input, which is a named range called "CurrMonthShort".

Is there a way, in the formula and not using VBA, to have the range in the SUMIF update to the current month each month? Essentiall,y if I cahnge the input to be "Mar", I want the SUMIF to lookin the range called "MAR_BUD".

 

[Andrew Poulsom]

Not tested, but try:

=SUMIF(Master!$A:$A,$A10&"_Y",INDIRECT(CurrMonthShort&"_BUD"))

 

[rdw72777]

It worked.

Wow, that little innovation could really save me some time in other areas...thanks.