# Find smallest 2 numbers from 3

#### bjbalmforth

##### Board Regular
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.

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### Von Pookie

##### MrExcel MVP
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))

##### MrExcel MVP
bjbalmforth said:
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

##### Board Regular
Thankyou, they both worked fine.

Replies
3
Views
955
Replies
6
Views
322
Replies
11
Views
202
Replies
1
Views
164
Replies
5
Views
334

1,195,936
Messages
6,012,393
Members
441,695
Latest member
MickRobertson

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back