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

Jim

opps! Should be:
=AVERAGE(IF(B2:B180,B2:B18))



Don

"JimNColorado" wrote in message
...
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?