I have a set of data that I am trying to turn into a table.

In column D I have a date amounts entered.
In column G I have amouts entered.

The Column Headings in Columns H - O are year amounts, eg. 2007, 2008, etc.

The equations in the body of H - O are IF statements that say that if the
Year in Col D = the Year in the Column Heading, then put in the amount from
Col. G., if not put in "". ( I have also tried putting a 0 in for the false
answer and get the same result.)

When I am in the Excel 2007 Non Table mode everything works fine. When I
try to convert to the Table mode, the values derived from the IF equations
all vanish.

The cells in Cols H - O all are blank and the totals line that I had above
the Data area turns to 0.

The IF statements are still there but its as if they were gone since nothing
shows up and the total have all turned to 0.

Any thoughts?

Thanks
--
Alan