I apologize, my title might not make sense. I will try to explain better what I am trying to do
Here is a formula I am working with, it works fine as is:
=SUMIFS('Acreage Values'!$X$3:$X$3565,'Acreage Values'!$J$3:$J$3565,"WES",'Acreage Values'!$E$3:$E$3565,$B16,'Acreage Values'!$BI$3:$BI$3565,"<>Neither")
I would like to modify it and make it easier to use. This is the sum_range portion: 'Acreage Values'!$X$3:$X$3565. I want to be able to call a cell that will change the 'X' in the sum_range to another column. For instance, if I want 'X' to be 'BC' instead. In cell E5 of the current sheet, I want to be able to type 'BC'. I then want a formula in my sum_range to grab whatever is in cell E5 and replace X with the contents of E5, in this case, BC. I just cannot figure out how to change the sum_range to make this happen.
This would be very helpful to me, I appreciate any help you can give me!