View Single Post
 
Old 01-07-2015, 07:42 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote