I am trying to take the quarterly average days for report deliverables, but some of the months the report is N/A.

Does anyone know a formula to not use the months with the N/A and only average the reports that have a number value? But if all 3 months are N/A the return result should be N/A.

My monthly results are not in a row. Month 1=column G. Month 2=column K. Month 3=column O.

Any help is greatly appreciated!!!

Try this:

=AVERAGE(IF(ISNUMBER(G1,K1,O1),G1,K1,O1))

This is an array function so you need to press CNTL-SHIFT-ENTER to enter the formula.

thanks! I forgot to post this as solved. I got it last night with this:

=IF(AND(G4="N/A",K4="N/A",O4="N/A"),"N/A",SUM(IF(G4="N/A",0,G4),IF(K4="N/A",0,K4),IF(O4="N/A",0,O4))/SUM(IF(G4="N/A",0,1),IF(K4="N/A",0,1),IF(O4="N/A",0,1)))

Which also solves for the issue if the denominator is zero.

Happy New Year!!

Ew...that's ugly. :-)

HAHA. But it works.

When I went to use yours it said there are too many arguments. I think this can only be used for 2 cell references? When I input the G & K "highlight" cell references but the O is not...

Yeah...I think it needs to be a continuous range. No matter. Sometimes all you're left with is ugly. Just put a bag over her head and carry on.