Hi,

You may mean this

=AVERAGE(IF(C10:N10<0,C10:N10,FALSE))

This will average c10:N10 excluding zero.
It's an array which must be entered with CTRL+Shift+Enter. If you do it
correctly Excel will put curly brackets around the formula {}. You can't type
these yourself.

Mike

"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.