View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JimNColorado JimNColorado is offline
external usenet poster
 
Posts: 2
Default How to average a column of numbers that are greater than 0?

That worked. Thanks. I would have never figured it out.

"bpeltzer" wrote:

I'll admit my bias against array formulas and offer an alternative...
Average is simply sum/count. So =sumif(range,"0")/countif(range,"0") will
average the positive values.

"JimNColorado" wrote:

I am trying to average a column of numbers. I want to only average the cells
that contain a number greater than 0. How do I do that?