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