Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! :-)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear the lowest 10 values from a list of 30 values | New Users to Excel | |||
Lowest two values | Excel Worksheet Functions | |||
Find lowest 3 values and sum | Excel Worksheet Functions | |||
Average of lowest 5 of 20 values? | Excel Worksheet Functions | |||
Dropping lowest 2 values | Excel Programming |