I read it that you are trying to exclude months that have a return of zero
or months that are still in the future. If so try:

=IF(C10=0,0,SUM(C10:N10)/COUNT(C10:N10))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"C Kreig" wrote in message
...
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.