How to write a formula to choose the greatest value

Occasional Visitor

I am needing help with a formula, where it chooses the highest value of 2 numbers and then adds that number to a list of numbers. 
5,7,        and it would chose the 7 to add to the sum of other numbers

1 Reply


Let's say the two values you want to take the highest of are in A1 and A2, and the other values are in A3:A10. The formula would be




or equivalently