Thread: Average formula where blank cells are counted as zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
krwelling krwelling is offline
external usenet poster
  
Posts: 1
Default Average formula where blank cells are counted as zeros
I am trying to write an average formula that takes into account the blank
cells.

I had only cells A2, A4, A6 filled out, but when I do =average(A1:A6), it is
not treating the blanks as zeros so the answer is much higher than it should
be.

Should I do a logic formula within the cells?
Reply With QuoteReply With Quote