I want to sum all data values in a row EXCEPT the lowest two
 

Hello everyone.

I am a new college math instructor, and I am using Excel to keep track of my
students' grades. I would like to be able to sum all the data values in a
particular row except for the lowest two values. (It's easy enough to leave
off the lowest value using the MIN function, but what about the lowest AND
the second lowest). I know I should be able to figure this out on my own,
but I just can't seem to be able to do it!!

Any help would be greatly appreciated!!

I want to sum all data values in a row EXCEPT the lowest two
 

Try something like this:
=SUM(B2:B30,-SMALL(B2:B30,{1,2}))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

"taj" wrote in message
...
Hello everyone.

I am a new college math instructor, and I am using Excel to keep track of
my
students' grades. I would like to be able to sum all the data values in a
particular row except for the lowest two values. (It's easy enough to
leave
off the lowest value using the MIN function, but what about the lowest AND
the second lowest). I know I should be able to figure this out on my own,
but I just can't seem to be able to do it!!

Any help would be greatly appreciated!!

I want to sum all data values in a row EXCEPT the lowest two
 

Excel has =small() function.

=small(a1:k1,1) is the smallest (same as =min(a1:a10))

=small(a1:k1,2)
will give the 2nd smallest

So...
=if(count(a1:k1)<3,"not enough numbers!",sum(a1:k1)-min(a1:k1)-small(a1:k1,2))

Another way to write it is:
=if(count(a1:k1)<3,"not enough numbers!",sum(a1:k1)-sum(small(a1:k1,{1,2})))

It may make it easier if you decide to ignore more tests.

(ps. There's another function named =large(), too.)



taj wrote:

Hello everyone.

I am a new college math instructor, and I am using Excel to keep track of my
students' grades. I would like to be able to sum all the data values in a
particular row except for the lowest two values. (It's easy enough to leave
off the lowest value using the MIN function, but what about the lowest AND
the second lowest). I know I should be able to figure this out on my own,
but I just can't seem to be able to do it!!

Any help would be greatly appreciated!!

--

Dave Peterson

I want to sum all data values in a row EXCEPT the lowest two
 

Something like this would certainly work:
=SUM(LARGE(A1:A10,{1,2,3,4,5,6,7,8}))


HTH,
Ryan
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"taj" wrote:

Hello everyone.

I am a new college math instructor, and I am using Excel to keep track of my
students' grades. I would like to be able to sum all the data values in a
particular row except for the lowest two values. (It's easy enough to leave
off the lowest value using the MIN function, but what about the lowest AND
the second lowest). I know I should be able to figure this out on my own,
but I just can't seem to be able to do it!!

Any help would be greatly appreciated!!

I want to sum all data values in a row EXCEPT the lowest two
 

Thank you to everyone that answered my question. I am stoked!! :-)