Hi creativeops and Ken,

Suggestion:
assuming that your AVERAGE formula would be on row 21

instead of
E21: =AVERAGE(E2:E20)

suggest using
E21: =AVERAGE(E2:OFFSET(E21,-1,0))

The offset indicates 1 row before, no chnages to column

The reason for the writing formula this way is so that you can
insert a row immediately above without having to change your
AVERAGE formula. For more information see
http://www.mvps.org/dmcritchie/excel/offset.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ken Johnson" wrote in message oups.com...
Hi creativeops,
does:
EditReplace...SUM in the Find what: box and AVERAGE in the Replace
with: box Click on Replace All button

do what you want?
I only tried it out on one cell with =SUM(E1:E20) and it worked OK.
Ken Johnson