Range Name within Pivot Table

[CliffMc]

Hi All,

This sounds like a simple problem, but I don't know the solution. I have a pivot Table with a range name within the table (range name is status). In a seperate worksheet I have a simple '=countif' formula using the range name status. My problem is this, if you drag and drop a field from the page area of the pivot table to the row area, the status column moves down one column, but the range name doesnt move with it, so the range name is still defined as column J while the actual data has moved to column K, and this causes my =countif formula to give me errors.

Any simple solution to my problems.

Thanks in advance.