# Sum best 8 out 10

## Sum best 8 out 10

I have a simple spreadsheet. Names in rows and game scores in cols. My example shows 3 names and 10 games. I want to calculate, for each player, the cumulative score for the best 8 games recorded. By best I mean highest scores. The game cells will either have a number inc zero in them or be left blank. Some players will have played less than 8 games (say 6) and then the total needs to sum up whatever they have played (say 6). The blanks need to be ignored in any calculation. I've limited excel experience can anyone help me please. spreadsheet attached. thanks Roger

ps: the final version of the spreadsheet will have 120 names and 40 games and require the best 20 out of 40; but I guess the principles will be just the same.

Visit publisher's web-site: Sum best 8 out 10

## Related Tutorials

### question about SUM - how to sum each for elements

I have a problem with function SUM.

I have column A with numbers, and column B where I want to sum

elements from column A by four numbers together. So I put into B:

SUM(A1:A4)

SUM(A5:A8)

SUM(A9:A12)

SUM(A13:A16)

etc.

Is there any chance, to do it automatically? I tried with everything what I know. If I simply mark this, and pull down, Excel make it:

SUM(A1:A4)

SUM(A2:A5)

SUM(A3:A6)

SUM(A4:A7)

etc.

I was tring with different adressation $ or without $. But I couldn't get that result.

### How to Sum<=40, sum, if >40 sum in next column

I am trying to sum a column of hours and minutes to calculate straight hours and overtime. If the sum is <=40, then sum; otherwise move excess to the next column. What is the folkway I should use to do this. I'm stumped.

### Sum formula

I've created a basic sum formula, lets say its just like SUM((A1*A2)+(B1*B2)). Normally when its more like SUM(A1:C1), I can take the final cell, drag it down and till do SUM(A2:C2) automatically. but when I draft this new one down, it changes it to SUM(A2*A3)+(B2*B3) and I want it to be drag it down and get SUM((A1*A3)+(B1*B3)) and then a1 a4 and b1 b4, etc

### Yearly sum

I have a column that I want the monthly sum and then the yearly sum, any way to make it easier?

A B

1 Jan

6 Sum 610

11 sum 310

13 December

16 sum 250

17 Year 1170 (=b6+b11+b16)

### Sum of an array

Is there anyway to sum a range of values given a specific number of cells you choose to sum. For example you have a range from A1:F1,

G1=number of cells you want to sum from left to right, and H1 is the total. So if G1=3, then H1=sum(A1:C1) or 16. If G1=5, then

H1=sum(A1:E1) or 20.

A B C D E F G H

1 3 5 8 3 1 7 Var Sum

## Related Applications & Scripts

### MySQL Database Report Generator

Generate your database reports with this wizard in only a few minutes on any of your existing MySQL databases. Since this is a php driven application you simply upload the application files to a folder within your web site and you are ready to generate reports. Execute statistical queries such as sum a column.

This MySQL database report tool is simple to use even for the novice. No coding experience required.

### Guess And Win Script

You need to guess the number (between 1-1000). When you come first time to the site you have 1 chance to guess the number, if you guess right you transfer to information page and you can prize from our Prizes page, but if you guess wrong, you dont have another chance to guess the sum.

You can get more chances by referring your friends, for 3 people that you refer you will get 1 chance to guess the number, or if you dont want to refer your friends you can donate the site by paypal, if you donate 1$ you get 1 chance to guess the number, if you donate 5$ you get 5 chances to guess the number. You have multiple revenue sources: Adsense, Adbrite, ClickSor, CPALead, etc, and donations by Paypal.

### Links PPR: Links directory management script

This script allows you to have links directory where link ranking in category and in search results is based at advertiser bids. It contains all advertiser features script for work with advertisers ( create profile, edit profile, add/modify/delete link, change bids, view stats, payment form).

It allows you to have bidded and non bidded links at directory. Paid links ranking depends on bids, all free links at the bottom of the category page.

All the links (including paid ones) require admin review before being included in the directory. Admin can show/edit/delete profile of every advertiser, change balance of advertiser, approve or decline link or/and money transaction, and email to all advertisers or those whose balance is as little as the requied sum ($5 for example - customizable), see earning stats.