Ignoring errors

The fomula in column N is =+SUMIF(B7:M7,">0")/COUNTIF(B7:M7,">0")
This works fine and averages only the month with money

Column O is a plugged number

Column P is also an average but when N returns "#DIV/0!" the same thing appears in P when I divide N/O

How can I return either a blank or 0?

Try:

=IF(COUNTIF(B7:M7,">0"),SUMIF(B7:M7,">0")/COUNTIF(B7:M7,">0"),0)

when you divide N/O you will also get that error...

so, then apply similar idea...