Yeah, that's it - thanks Ken. Duh, I don't know why I didn't realize that.


"Ken Johnson" wrote:

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