Excel 2007 Tables Absolute References / Named Ranges

[Maverick99]

This question actually involves both the use of Absolute References and Named Ranges within a Excel 2007 Table.

There is a Formula in a spreadsheet, say, E18 (A1 mode) that has the following variables (it also works):

=SUMIFS(Data_PI[Income],Data_PI[Accounting Period],E4,Data_PI[LAB_NAME],PI_Name,Data_PI[Fiscal  Year],E6,Data_PI[Project],$B$16)

Data_PI is the name of the Table.

Then by using the cell handle to drag and copy the Formula to F18, the code changes, including the Table Headings, to the following:

=SUMIFS(Data_PI[Transfers&Adj],Data_PI[Free Balance],F4,Data_PI[DeptID],PI_Name,Data_PI[Balance Sept 1st],F6,Data_PI[LAB_NAME],$B$16)

Each of the names represents column headings of the Table. But the changing of the Table Headings is not wanted.
I tried setting each of the Table Ranges to a Named Range, as Named Ranges were supposed to be somewhat static, referring to what was entered. For Instance:

PI_PID = Data_PI[Project]

However, exact same issue arose, when trying to copy from E18 to F18. This time, the value of the Named Ranged [PI_PID] was changed to [PI_LabName], which had a Named Range value of:

PI_LabName = Data_PI[LAB_NAME]

Most Ranges can be set to absolute by using the $ ($E$18). The question is: Is there way to use Excel 2007 Table Ranges and make them absolute so they can be copied to other cells and not change?

Thanks,

Maverick