Inserting rows above formula: how to?

[Jennifre]

Hi, I'm a dunce in Excel, but actually managed to insert an "average" formula, though would like to add more data above it, to average more cells.

If this is answered in another thread/post here, feel free to send me its link. I was unable to find it.

I saw something on another site talking about doing this by naming a span of cells and crafting the formula around this named area, which would allow you to insert rows above the formula cell, though that did not work for me. The site showing this talked about creating a border around the cells in question, though I didn't think that was actually necessary, and I *think* I named the span of cells correctly, though the formula then shows the specific cells, and if I insert rows above the formula, the formula still shows the original cell span.

To wit:
=AVERAGE(BQ26Average Concern)

(I think that BQ26 shouldn't be named. And the row I added above the formula is BQ28.

Sorry for being such a dunce. I feel like this is a simple thing, likely.

Thanks for any help!

 

[ziad alsayed]

i am not getting you clear, let say that your data are from A2 to A6 (A1 is the heading). now in A7 you have the average formula. if you add any row between A2 and A6 the formula should update automaticaly.

please this is not the case , just explain better to me to follow it up.

check below example

Excel Workbook
	A
1	qty
2	1
3	2
4	3
5	4
6	5
7	3
Sheet1

Excel 2010

Cell Formulas
Range	Formula
A7	=AVERAGE(A2:A6)