View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
c. murphy c. murphy is offline
external usenet poster
 
Posts: 1
Default Averaging numbers in a column while excluding blank spaces and zer

I am using office 2003 and have the numbers 0, 0, 5, 0, 0, 5, 0, 0, 5, 0, 0,
5 in column G. How do I average only those blocks that contain a number
greater than zero no matter what blocks in that column might contain a number
greater than zero?

Thank You