Excel Table formula
Posted on 2011-05-06
Hi, I am working on a report in excel that is doing a sumifs to a particular table. I would like to use a variable to switch columns for the sum range so I can just change a cell and it would calculate.
Here is my formula:
This works just fine however, I would like to use a formula like this:
Then cell A1 would have "Division1"
That way all I would need to do is change cell A1 to "Division1" or "Division2" etc and I could use the same report for various division by simply changing the value in cell A1
I can't come up with the formula! Anyone got a suggestion?