|
|
#3
01-07-2015, 08:09 AM
|
|||
|
|||
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!! 
|
|
|
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