Hi,
I want to use the SUMIFS function to add the values in $AS$1:$AS$2000 based on the criteria_range $A$1:$A$2000 and criterion in cell AZ1.
Rather than selecting the sum_range and criteria_range directly (e.g. by typing in or selecting the range with the mouse) I would like to build these references using formulae.
This is important because the sum_range may not always be in column AS.
The column for the sum_range will be determined by its heading - so, for example, the data with the required heading may be in column AS this month and AV the next, so I would like to make the references dynamic.
Can someone please suggest a solution.
I have tried ADDRESS and OFFSET without success.
Thanks!
I want to use the SUMIFS function to add the values in $AS$1:$AS$2000 based on the criteria_range $A$1:$A$2000 and criterion in cell AZ1.
Rather than selecting the sum_range and criteria_range directly (e.g. by typing in or selecting the range with the mouse) I would like to build these references using formulae.
This is important because the sum_range may not always be in column AS.
The column for the sum_range will be determined by its heading - so, for example, the data with the required heading may be in column AS this month and AV the next, so I would like to make the references dynamic.
Can someone please suggest a solution.
I have tried ADDRESS and OFFSET without success.
Thanks!