How to write a formula to choose the greatest value

Copper Contributor

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

@PbMWpp 

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

 

=SUM(MAX(A1,A2),A3:A10)

 

or equivalently

 

=MAX(A1,A2)+SUM(A3:A10)