Excel Tables are a convienient way to arrange and reference your data in a spreadsheet.
However I had an infuriating problem with formulas not working within my table. No amount of cell reformatting, cutting and pasting, or resizing table dimensions seemed to cure the problem.
However, it was really quite simple. Formula’s in Excel 2007 tables are CASE SENSITIVE as you can see from the attached image:
Write case-sensitive formulas and you will be fine!