Thread
:
Taking Averages with N/A's
View Single Post
01-07-2015, 07:42 AM
gebobs
Windows 7 64bit
Office 2010 64bit
Expert
Join Date: Mar 2014
Location: Atlanta
Posts: 837
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.
gebobs
View Public Profile
Find all posts by gebobs