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!