I have the following SUMPRODUCT formula where I'd like the sum range to refer to a dynamic named range, i.e. the sum range will be the concatentation of a given cell value plus additional text to refer to a named range of the same name.
For example:
Cell B10.value = "ABCWidget", and the named range I want the SUMPRODUCT sum range to refer to is: ABCWidgetTotalCostOfMedia
Probably a simple solution, I'm just not seeing it... thanks for any help!
For example:
Code:
=SUMPRODUCT(--(YEAR(LifeCycleMonths)=OFFSET(C12,-2,0)),--(B10&TotalCostOfMedia))
Cell B10.value = "ABCWidget", and the named range I want the SUMPRODUCT sum range to refer to is: ABCWidgetTotalCostOfMedia
Probably a simple solution, I'm just not seeing it... thanks for any help!