I have a formula as below. It's a dynamic range sumif
Column B has four tags, "Actual, Forecast, Variance, Variance %",
Then in each column after B, I have number and dollar values.
I want to add them with a dynamic range as above. Interestingly the formula works for the first column (C), but when I drag across the formula to the next columns, the number doesn't update and I get the same value as Column C total.
If I go into Column D formula:
Make it an array then, un array it, the value updates and I get the value I want.
Why doesn't it automatically update and is there a better way to do this?