Iserror

[kelljeff]

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!!!

 

[Dave Peterson]

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]

Thank you so much!!!

I the second way perfect....