subjects
First, the first student achievement scores of all subjects, and then by copying function scores of other students in various subjects.

1. Calculation of the total students in the first
(1) select the function. Select cell H4, menu bar and then click the "Insert/Function" or the toolbar "fx" button, and then pop-up "Paste Function" dialog box, first of all, in the dialog box "Function Categories" column to select " Mathematics and trigonometric functions ", and then in the" function name "select" Sum "click" OK "to exit.

(2) select the range of requirements. Select function after open "function parameters" dialog box, and then click "fold dialog" button (that is, the right button Number1), when the dialog box disappears, and then select the range, select the method (click to drag C4 C4 by G4 or click Shift key while clicking the G4), the last must press the "Enter" to confirm that the "function parameters" dialog box appears again, click the dialog box "OK" button can be obtained from the following Total students first.

2. Calculation of total subjects other students
Click H4 cells, mouse cells point to the lower right corner of the small black box (that is, fill handle) until the cursor into a black "10" character, press the left button down drag the mouse to the H13, subjects score can easily show (based on the need to choose a different data processing functions, such as the Max function with the highest score, Min calculation of the minimum hours, Average grade average).

1 in accordance with the second score. The named range
First, select the "Total" data range of the H4-H13, and then click menu "Insert/Name/definition of" in the pop-up "the definition of the name" dialog box that "the current workbook name" column input or modify the name to "Total" in the "reference position" column shows the range just select the H3-H16 (of course, you can click to the right of the "collapse button" re-select the range), and then press "OK" to exit.

2. Select the function to determine the top
I3 in the cell, type "rank" the cell I4 click, select "Data/Function" menu item or click the toolbar "fx" button pop-up "Paste Function" dialog box, select "Statistics" category "RANK" function that is the pop-up "function parameters" dialog. Number column in the importation of H4 (or click the right "button folding" dialog box disappears, click H4 and press "Enter", this column is just the selected cell H4), Ref column Enter the "Total", click "OK" button can be out of the scores of pupils in the first place, and then select the cell J3, through the "copying handle" to copy, come to class results in the rankings.

statistics the number of branches of the scores of paragraph

in A14-A19, respectively, enter "49 points or less," "50-59 hours", ... "90 points", the first statistics on the "high number" results in "49 minutes" and the number of methods for total basically the same, just choose a different function. In the "Function Category" select "Statistics", in the function name to select COUNTIF (G3: G65,> = 80), pop-up "function parameters" dialog box, select the Range column or enter the calculation of regional C4 ~ C13 in the Criteria column type "<= 49", click "OK" button once to withdraw from the C14 in the number of conditions are met. Between 50-59 minutes to the number of statistics in the Criteria column as long as the importation of "> = 50 AND <= 59" can be. Can be calculated the same way the number of other points above, finally, obtained through various methods of reproducing the number of the points above.