Is there any way to average a range of cells when some have the #/DIV0! error in them?
Is there any way to average a range of cells when some have the #/DIV0! error in them?
Hi
Perhaps:
=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))
Confirmed with Ctrl+sHIFT+eNTER. It is an array formula so Excel will surround with curly braces {} is entered correctly - do not try and enter these manually yourself.
Richard
Richard Schollar
Microsoft MVP - Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks