KP_SoCal
asked on
Dynamic “sum_range” in with SUMIFS function in Excel 2007
In the attached excel spreadsheet on the “Results” tab in column B, I’m using a basic SUMIFS function. You’ll see my “sum range” is set to column Q on my “PivotTable” worksheet tab.
I need to make this formula dynamic due to the fact my “Grand Total” range may not always been in column Q. Any ideas?
Pivot-Example.xlsx
I need to make this formula dynamic due to the fact my “Grand Total” range may not always been in column Q. Any ideas?
Pivot-Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ms. Teylyn,
This is precisely what I needed! Thanks so much!!!
KP
P.S. Also thank you for the extra explanation. =)
This is precisely what I needed! Thanks so much!!!
KP
P.S. Also thank you for the extra explanation. =)
It identifies the column by looking for the text "Grand Total"
cheers, teylyn