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