referencing one column in a formula and changing it.

I am having sum of numbers(of various sheets) in each cell from AA1 to AM100
from BA10 to BM110 having the 10cell averages of AA1 to AM100
like BA10 having formula =average(AA1:AA10)
similarly into other cells BA10-BM110 having averages of AA1-AM100
in A10 to M110 cells having if formula
like M110 having =if(BM110>150,"OK","NOT")
everytime cell number increases this sheet having very labour and if there is any simplifying methods to reducing cell quantity and formula cells quantity please mention.


I am imagining how it should be better to look good and work good.
the cells AA1 to AM100 having numbers. It is necessary
in B column the average of one column and in A column if-condition for the depending column AA

in C1 column I write AA
first time it shows the results for AA column
like in B10 cell average of AA1:AA10 and in A10 cell OK or NOT
when I change C1 column as AB
then the B column and A column shows results depending on the AB column
like in B10 cell average of AB1:AB10 and in A10 cell OK or NOT
.......................Any formulas or suggestions for this work sheet by reducing burden and simple methods please mention.