Thread: No including ZERO'S when using Average fucntion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gudmundur Gudmundur is offline
external usenet poster
  
Posts: 1
Default No including ZERO'S when using Average fucntion
I am using the average function in a large documents for different time
periods. Some time periods have ZERO, which bias the average.

Can I use the average function but not have it count zeros in the total?
Reply With QuoteReply With Quote