a sum of #'s minus the lowest two values
=SUM(A3:J3)-SMALL(A3:J3,1)-SMALL(A3:J3,2)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Rynefan" wrote in message
...
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
|