Thread: Average (if)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed
 
Posts: n/a
Default Average (if)

Hi, how can I set a cell to get the AVERAGE of a row, but to exclude the
cells that contain 0, rather than use those 0's for the calculation?

thanks in advance