|
|
#1
01-06-2015, 10:10 AM
|
|||
|
|||
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!!! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Taking away text-wrap
|
ShankedS | Word Tables | 9 | 01-13-2015 01:25 PM |
| Moving averages of data points with a changing sampling interval | jrosen | Excel | 3 | 10-23-2014 06:26 AM |
| Taking pictures out of text boxes | cryptogram | Word | 15 | 03-10-2013 04:01 AM |
| MS word taking over file extensions | jakes | Word | 0 | 10-22-2010 01:35 AM |
| WORD taking up entire CPU!!! | pureride | Word | 0 | 03-28-2008 09:46 AM |
Windows 8 
Office 2010 64bit
Threaded Mode