Thread: Need help (Average excluding zero values)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Need help (Average excluding zero values)
This is what i have & it works but one problem there will be zero values & i
need to exclude them if possible
=AVERAGE(IF(AA5="L",E$5:E$65))
I have tried several different combinations I can,t get it
Reply With QuoteReply With Quote