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,108,814
Messages
5,525,047
Members
409,616
Latest member
ULFireTester

This Week's Hot Topics

Top