View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default any suggestions?

The problem is the plus sign- AVERAGE requires that the arguments are
separated by a comma. Try this:
=(AVERAGE(IF(ISNUMBER(G20),G20),(IF(ISNUMBER(M20), M20))))
....and you'll get the desired results.