a sum of #'s minus the lowest two values
Try something like this:
=SUM(A1:A10)-SUM(SMALL(A1:A10,{1,2}))
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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
|