=SUMIF('2014 Sales'!$CR$1:INDEX('2014Sales'!$CR:$CR,A15_2014_Sales),$AR594&"*",'2014Sales'!$F$1:INDEX('2014 Sales'!$F:$F,A15_2014_Sales))
In the above formula the Reference to Column F is a changeablereference.
i.e – F = January / L = Feb / R = Mar, etc…
I need to copy this formula in to new columns – what’sthe best way to update the F to L, and so on, in all the formulas?
Any one understand what I mean and can help?
In the above formula the Reference to Column F is a changeablereference.
i.e – F = January / L = Feb / R = Mar, etc…
I need to copy this formula in to new columns – what’sthe best way to update the F to L, and so on, in all the formulas?
Any one understand what I mean and can help?