in short i am trying to use or create a formula that will give me the average
of the sum of numbers in a list or a table where the numbers to be added is
based off a static cell that contains a number that will range between 1 and
300.

ie... static cell(E7) will contain the number 1-300
... the table or list will also have the corresponding 1-300
i want the formula to look like this...
if(e7=93,avg(sum(g1:g93))) but the problem is I dont want to use the IF
formula i want it just to do the average based on E7...
It sees that e7 is 93 and knows only to sum 1-93 and then give me the
average of the sum and if the number in e7 should change it will recalculate
and give a new answer. Now I am pretty new to this kind of
programming/formulas and am at a stand still and do not know what to do.