Taking Averages with N/A's
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!!!
|