I need to find the average of a range of cells, A7:A11. However, I will
insert a row in front of A7, causing the original A7 to become A8. I
still want the formula to refernce A7:A11, and just drop the cell that
got pushed out. However...

Regardless of the static symbol($), my reference is still moving to
A8:A12, following the original group of numbers.

I thought the static should stop this, but it doesn't.


Thanks for any help

Paul


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=474314