Thread: How to average random cells with out counting zero?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to average random cells with out counting zero?

=(A1+A8+A16+A24)/((A1<0)+(A8<0)+(A16<0)+(A24<0))

--
Gary''s Student - gsnu200850


"Alex" wrote:

I am trying to average every 8th cell in a column, however I do not want to
average zeros,
=AVERAGE((IF(A1=0,"",A1)),(IF(A8=0,"",A8)),(IF(A16 =0,"",A16)),(IF(A24=0,"",A24)))

is what I came up with but it gives the "#value" error! Please help
Reply With QuoteReply With Quote