View Single Post
  #1   Report Post  
Stephen
 
Posts: n/a
Default Average Cells above 0

Hi Everone! I'm trying to average a group of cells, but only the cells over 0.
I tried this - =average(if(i2515:i5043)0,i2515:i5043)). I also entered it
as an array but it still didn't work. Please help!

--
Thanks!

Stephen