a sum of #'s minus the lowest two values
I tried them and they all work.
Thanks everyone. I love this site.
"Gord Dibben" wrote:
I'm sure there are shorter methods but this one works.
=SUM(A3:J3)-SUM(SMALL(A3:J3,{1,2}))
Gord Dibben MS Excel MVP
On Mon, 9 Apr 2007 15:28:00 -0700, Rynefan
wrote:
sum(a3:j3)-min(a3:j3)
I know how to not factor in the least number from a string (as shown above)
but how do I change the formula to not consider the 2 least values?
I am using Excel 2000
Thanks
|