Thread: Average Functin
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nielz Nielz is offline
external usenet poster
  
Posts: 1
Default Average Functin
Todd,

You could try sum / sumproduct. Ex. =SUM(A1:E1)/(SUMPRODUCT((A1:E1<0)*1))

"Todd" skrev i en meddelelse
...
How do you average a column that contains formulas, when some of the
formula
results are zero?
--
Todd


Reply With QuoteReply With Quote