You are here: HomeExcelTutorials

Sum best 8 out 10

Sum best 8 out 10

Price: FREE

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

Category and Tags: ExcelTutorials :

Related Tutorials

question about SUM - how to sum each for elements

Free: Yes
Tags: Excel ›

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

Free: Yes
Tags: Excel › Functions

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

Free: Yes
Tags: Excel ›

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

Free: Yes
Tags: Excel ›

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

Free: Yes
Tags: Excel ›

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

Free: No
Tags: PHP › Excel MySQL

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

Free: No
Tags: PHP › Excel Games

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.