Excel Magic Trick 1167

Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functions

DESCRIPTION

See how to Substitute Final Score If Greater Than Low Score using the MAX, MIN & SUM Functions.

Adam Goodrich From YouTube gave us this cool formula!

MUCH easier formula:

=SUM(A6:E6)-MIN(A6:E6)