View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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