In Excel, how to select and then add up the best 6 scores out of 7

G

Guest

How do I set up a spreadsheet which will select and then add up the best six
arithmetical scores out of 7? Any help would be appreciated.
The version is Excel 2002 with SP3 running in Windows XP Home version.
 
G

Guest

Let's say you have the seven scores in column A and best is highest ( not
like golf ), then in an un-used cell enter:


=SUM(A1:A7)-MIN(A1:A7)
 

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

Top