Mike-
You rock! Once I figured out the Array it worked!!

"Mike H" wrote:

Read my first reply again and enter the formula as an Array

Mike

"C Kreig" wrote:

Mike-
Thank you for your help, however I did this and now I get the #Value.
Please advise.


"C Kreig" wrote:

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.