| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need a formula to add the 3 lowest numbers out of 5.
Trying to sum the three lowest numbers from 5 values.
Thanks |
|
#2
|
|||
|
|||
|
"Humbie" wrote...
Trying to sum the three lowest numbers from 5 values. =SUM(SMALL(Your5NumbersHere,{1,2,3})) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formula where high and low numbers are excluded | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
| Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
| Formula for comparing 3 numbers and resulting in the lowest of the | Excel Worksheet Functions | |||
Linear Mode
