Formula solution without VBA

rdw72777

Well-known Member
Joined
Apr 5, 2005
Messages
723
I have the following formula:

Code:
=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".
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

rdw72777

Well-known Member
Joined
Apr 5, 2005
Messages
723
It worked.

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

Watch MrExcel Video

Forum statistics

Threads
1,113,903
Messages
5,544,964
Members
410,645
Latest member
aroesch
Top