K
kelljeff
This is most likely a really easy questions... But I've gonecompletely blank.
Below is my formula... Why is it not working.
=SUM(ISERROR(E4:M4)/B4,"0",E4:M4)/B4
Please help!!!
This is most likely a really easy questions... But I've gonecompletely blank.
Below is my formula... Why is it not working.
=SUM(ISERROR(E4:M4)/B4,"0",E4:M4)/B4
Please help!!!
D
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)
=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)
K
kelljeff
Thank you so much!!!I the second way perfect....