Thread: Creating If Statement not to include if O in average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
C Kreig C Kreig is offline
external usenet poster
  
Posts: 21
Default Creating If Statement not to include if O in average
Good afternoon!
I have a spreadsheet that includes all 12 month, however when it figures the
yearly average I do not want it to include it when it does the average. I
have posted the formula below. Can you please help me figure this out.
=IF(C10=0,"0",AVERAGE(C10:N10))
Thank you in advance for your help.
Reply With QuoteReply With Quote