Formulas not autofilling in 2010 Table

Hi all

I have a general questions about a table I have in 2010 Excel.
My table is currently W10:ax268.
When I put a new value in z269, the table detects this and adds the new line. It also drags down formulas in multiple columns, the most complex being the following:
=IF(AND($AN$5<>0,$AN$6=0),CEILING(AJ268*$AN$5,5),IF(AND($AN$6<>0,$AN$6=0),AN268*$AN$6,"ERROR!!"))

Column AS has a formula, but is not automatically filling in the same way the other formulas are. This formula in column AS is the following:
=IF(COUNTIF($X$10:$X$270,X268)>4,AVERAGE(SMALL(IF($X$10:$X$270=X268,$AM$10:$AM$270),$AS$5)*$AS$6,SMALL(IF($X$10:$X$270=X268,$AM$10:$AM$270),$AT$5)*$AT$6,SMALL(IF($X$10:$X$270=X268,$AM$10:$AM$270),$AU$5)*$AU$6,SMALL(IF($X$10:$X$270=X268,$AM$10:$AM$270),$AV$5)*$AV$6)*4,AVERAGE(IF($X$10:$X$270=X268,$AM$10:$AM$270)))

I just realized while typing this that the formula is an array formula. This is possibly why the table is not autofilling.

Does anyone know if this is the reason, and if there is a way to make the table automatically draw down the formula?

Thanks!

No. Not sure why the spaces were in there, but in my file they are not. The formula works perfectly, and if the tables expands to row 269, the cell references in the previous cells change accordingly, which is VITAL, but the formula itself does not appear in AS269.

Formula:

Please Login or Register  to view this content.

I attached a copy of the file.
If you enter a character into cell Z269 and hit enter, the table will automatically include the new line in the table, but I now notice there are TWO issues occuring:
1 - the formula in cell W268 changes from referencing $x$10:x268 to $x$10:x269, which I do NOT want to happen. I want cell w269 to reference $x$10:x269.
2 - the formula in column AS changes in previous rows to now include row 269, which I want, but the formula does not appear in cell AS269.

Any ideas?