Thread: from a group of cells.find average of cells containing values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Billy Liddel Billy Liddel is offline
external usenet poster
  
Posts: 527
Default from a group of cells.find average of cells containing values


"farm" wrote:

average some specified cells using only those with values greater then 0

Hi

Try =SUM(A1:A6)/COUNTIF(A1:A6,"0") where A1 to A6 is the range

Regards
Peter
Reply With QuoteReply With Quote