Thread: Average If (Value between 1 and 100)
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
  
Posts: 740
Default Average If (Value between 1 and 100)
i inherited now a typo habit !

You will have 0 result on M8, when L8 has Value and H8 has no data yet ?
*Average will fail, even for the viewers.*

Reply With QuoteReply With Quote