LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
taj taj is offline
external usenet poster
 
Posts: 5
Default 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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to clear the lowest 10 values from a list of 30 values fap87 New Users to Excel 3 April 3rd 09 07:40 AM
Lowest two values Muz Excel Worksheet Functions 4 July 29th 08 08:41 AM
Find lowest 3 values and sum AussieBec Excel Worksheet Functions 6 August 2nd 07 01:12 PM
Average of lowest 5 of 20 values? Fatfreek Excel Worksheet Functions 5 June 16th 06 03:49 AM
Dropping lowest 2 values merjet Excel Programming 1 October 2nd 03 06:06 AM


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"