ExcelBanter - I need a formula to add the 3 lowest numbers out of 5.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need a formula to add the 3 lowest numbers out of 5. (https://www.excelbanter.com/excel-worksheet-functions/17358-i-need-formula-add-3-lowest-numbers-out-5-a.html)

Humbie

I need a formula to add the 3 lowest numbers out of 5.

Trying to sum the three lowest numbers from 5 values.

Thanks

Harlan Grove

"Humbie" wrote...
Trying to sum the three lowest numbers from 5 values.

=SUM(SMALL(Your5NumbersHere,{1,2,3}))

All times are GMT +1. The time now is 04:01 AM.