Spill Error in Excel when using Table format.

I agree with mathetes

For an array formula to work within a Table it must return only a single value; no spilling allowed.  In such situations it can be useful to have the Table replicate the formula down the column to produce equivalent calculations for each record.

For array formulas that return multiple results as a spilt array, then one must place the formula outside the table, ideally with an intervening blank column (which can be reduced in width).  As rows are added to the data table, the dynamic array formula will adjust accordingly if it involves a structured reference.