Combine Two Formulas

Working on the same simple chart NBVC helped me on, but this is for AVERAGE instead of SUM and with an added variable.

I've come up with this, which works:

=IF(COUNTIF(B3:B14,">0"),(AVERAGE(B3:B14)))

Then needed to add; IF(B17,"N/A"). I tried using AND getting an error of too many arguments?

This also works to give me N/A but not the the AVERAGE I need if B17 is not N/A:

=IF(COUNTIF(B3:B14,">0"),IF(B17,"N/A"),(AVERAGE(B3:B14)))

Thanks for your help!

Not quite sure that's working out. I have never used that, so it may be me.

B17 says N/A when it can't get a total from the all 12 months from above.
If B17 says N/A I need B16 (cell to hold this formula) to show the AVERAGE of the 12 months. If B17 has a total, then B16 needs to show N/A.

I also still need COUNTIF in there too, I need a 0 showing with no data for the above months. (COUNTIF(B3:B14,">0")

Having the same problem with that formula as I was mine.

It gives me N/A preceded with a # sign (not sure why), but is still will not calculate the AVERAGE when all the values are not available.

Here is the file so you can see what I have so far.

Thank you again for the help!

So I didn't know if you only wanted the average of the months with values or the months with the zero months included. So if you want an average of just the months available, try.

=IF(COUNTIF(B3:B14,">0")=12,"N/A",ROUNDUP(SUM(B3:B14)/COUNTIF(B3:B14,">0"),0))

If you want the monthly average including the 0 months try:

=IF(COUNTIF(B3:B14,">0")=12,"N/A",ROUNDUP(AVERAGE(B3:B14),0))