Function question

N

Neil Grantham

Hi

Is there a function that I can total the best x of y cells?

Example:
I am totalling scores over 6 rounds of which only the best 4 will count

Neil
 
P

Paul Corrado

Sounds like Golf so maybe SMALL instead.

PC


Don Guillett said:
take a look at LARGE

--
Don Guillett
SalesAid Software
Granite Shoals, TX
(e-mail address removed)
Click to expand...
 

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

Help with cell reference 3
Averages - Golf League Scoring 12
How do I add the 9 highest numbers out of 12? 2
how to sum 'n' largest values *not* in an array? 7
Problem with MATCH function 5
Errors in Excel 2007 Calculation 3
CONDITIONAL COUNTIF FUNTIONS PLEASE HELP!!! 8
Golf best 2 out of 4 scores 7

Top