Edit|Replace
what: Average(
with: =average(
As long as Average( only occurs at the beginning of each cell in your selected
area.
It'll screw up on cells like:
=if(a1=5,average(b1:b10),average(c1:c18))
phshirk wrote:
Would prefer not having to enter = manually in each cell.
--
Dave Peterson
|