How can I sum a list of numbers EXCEPT the lowest value in Excel?

G

Guest

I have a list of test scores that I want to sum, but I want to drop the
lowest value. How can I do that in Excel?
 
R

RagDyeR

Try this:

=SUM(A1:A10,-MIN(A1:A10))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have a list of test scores that I want to sum, but I want to drop the
lowest value. How can I do that in Excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the lowest number? 3
difference between the lowest and next lowest value 4
Excel finding top of range 1
lowest of two closest numbers 13
how do I calculate the total of the lowest 10 numbers in an array 7
remove lowest 2 values in a row? 2
How to highlight the lowest valued cell in a column in Excel 2003 2
How can I find the 10 lowest numbers in a list? 5

Top