Iserror
 

:confused: This is most likely a really easy questions... But I've gone
completely blank.

Below is my formula... Why is it not working.

=SUM(ISERROR(E4:M4)/B4,"0",E4:M4)/B4

Please help!!!


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=542899

Iserror
 

It looks like you want:
=if(iserror(sum(e4:m4)/b4),0,sum(e4:m4)/b4)

If the only problem that might occur is that B4 is 0 (or empty):
=if(b4=0,0,sum(e4:m4)/4)



kelljeff wrote:

:confused: This is most likely a really easy questions... But I've gone
completely blank.

Below is my formula... Why is it not working.

=SUM(ISERROR(E4:M4)/B4,"0",E4:M4)/B4

Please help!!!

--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=542899

--

Dave Peterson

Iserror
 

:) Thank you so much!!!

I the second way perfect....


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=542899