#Div/0! help needed

[nigelk]

Hi all,

I have the following formula:

=SUM((1/J3)+(1/K3)+(1/L3))

if one or more entries is 0, I get the Div error.

Is there a way that it will still calculate anything that is not 0?

Thanks,Nigel

 

[SteveO59L]

What would you like to return in the case of an error? 0 or 1 ?

 

[barry houdini]

Try

=IF(J3,1/J3)+IF(K3,1/K3)+IF(L3,1/L3)

or an array formula confirmed with CTRL+SHIFT+ENTER

=SUM(IF(J3:L3,1/J3:L3))

 

[Andrew Poulsom]

Or:

=SUM(IF(J3,1/J3),IF(K3,1/K3),IF(L3,1/L3))

 

[nigelk]

Thank you all. Once again, problem solved!

Nigel.