sum formula to exclude zero values

[nmginn]

hi all,
im using the below formula to find the two lowest scores out of three but im trying to make it exclude any zero values, appreciate any help

=IFERROR(SMALL(D51:F51,{2})+SMALL(D51:F51,{1}),"")

[Fotis1991]

Try this ARRAY formula.

=SMALL(IF(D51:F51<>0,D51:F51),1)+SMALL(IF(D51:F51<>0,D51:F51);2)

[nmginn]

many thanks that seems to be working, didnt want to know at first but sussed out last part you put semi colon instead of comma,

many thanks for your help

Nigel

[Fotis1991]

many thanks that seems to be working, didnt want to know at first but sussed out last part you put semi colon instead of comma,

many thanks for your help

Nigel

You are welcome

It's because in Greece we use semi colons and not comma as separators.

I always have to change the semi colons to comma for showing my formulas, but sometimes(like now)i don't see ALL semi colons in my formulas...

[Tony Valko]

If there is only 1 number greater than 0 then what result do you expect?