Find smallest 2 numbers from 3

[bjbalmforth]

I need a formula that will say the following,

I have 3 cells which each contain a number I want to be able to find the smallest 2 values, but if a cell contains a zero or no data then add the remaining 2 numbers.

A2 B2 C2
78 80 77 = 155

A2 B2 C2
0 75 75 = 150

As you can see the zero would not be counted.

 

[Von Pookie]

I'm sure there's a better way, but this seems to be working for me:

=IF(ISERROR(MATCH(0,$A1:$C1,0)),SUM(SMALL($A1:$C1,{1,2})),SUM($A1:$C1))

 

[Aladin Akyurek]

I need a formula that will say the following,

I have 3 cells which each contain a number I want to be able to find the smallest 2 values, but if a cell contains a zero or no data then add the remaining 2 numbers.

A2 B2 C2
78 80 77 = 155

A2 B2 C2
0 75 75 = 150

As you can see the zero would not be counted.

=SUM(A2:C2)-IF(COUNTIF(A2:C2,">0")=3,MAX(A2:C2),0)

 

[bjbalmforth]

Thankyou, they both worked fine.