View Single Post
 
Old 01-06-2015, 10:10 AM
lynchbro lynchbro is offline Windows 8 Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default 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!!!
Reply With Quote