Trying to subtract the two lowest values from a row of numbers
=SUM(A:A)-SUM(SMALL(A:A,{1,2}))
"JAIrvin" wrote:
I'm trying to come up with a formula that will let me add all but the lowest
two values in a series (row) of numbers. I can add all but the lowest by
using the MIN function to find the lowest value (and then subtract it from
the sum of all the values), but I can't figure out how to find the second
lowest value.
Any help would be appreciated.
|