Good Morning Excellers
A B C D
1 1 1 0.5
2 #DIV/0!
3 1 1
4 TOTAL #DIV/0!
Formula in Column D is =1/COUNTA(A1:C1) - this is replicated for Rows 1,2,3
Because Row 2 is blank the formula returns #DIV/0!
I want to remove #DIV/0! so that I can total the values in D4
I have tried several versions of IF(ISERROR, but Excel always tells me that I have entered too many arguments.
Is there any way out of this?
With Regards
Try one of these:
Pre-Excel 2007
=IF(COUNTA(A1:C1),1/COUNTA(A1:C1),0)
Excel 2007 or later
=IFERROR(1/COUNTA(A1:C1),0)
Does that help?
It worked perfectly Ron, thanks a million.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks