# Sum the two smallest values between three values

Topic Labels: Formulas
Solved
247 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hello,

I need to sum the two smallest values between three values.
Example:
- Value 1: 10
- Value 2: 20
- Value 3: 30

The two smallest values are "Value 1" and "Value 2".

How to do this via a formula (or other

1 Solution

Accepted Solutions
9 - Sun

This is a possible solution to create the calculation - you could create a formula that sums up all three values, then subtracts the largest value among the three using MAX() -> this gives us the sum of the two smallest values among the three (because it subtracts the largest)

I hope this helps!

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com

2 Replies 2
9 - Sun

This is a possible solution to create the calculation - you could create a formula that sums up all three values, then subtracts the largest value among the three using MAX() -> this gives us the sum of the two smallest values among the three (because it subtracts the largest)

I hope this helps!

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com

4 - Data Explorer