DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate - View Single Post

**TeemFilla** · 09-12-2006, 08:45 PM

I also have an Excel question.

I have a list that's constantly growing. Now it's from, say, A1 to A45.

I also have a bunch of statistics i'm deriving from this list. For example: AVERAGE(A1:A45). Now, every time I add another cell to list, I have to go over all the statistics cells and update A45 to A46 in every one of them. I have a hunch that this is not the most efficient method.

Is there a way to get all the statistics cells to update automatically whenever the list grows?

09-12-2006, 08:45 PM	#3
TeemFilla Join Date Oct 2005 Posts 491 Senior Member	I also have an Excel question. I have a list that's constantly growing. Now it's from, say, A1 to A45. I also have a bunch of statistics i'm deriving from this list. For example: AVERAGE(A1:A45). Now, every time I add another cell to list, I have to go over all the statistics cells and update A45 to A46 in every one of them. I have a hunch that this is not the most efficient method. Is there a way to get all the statistics cells to update automatically whenever the list grows?
	Quote