abc MICROSOFT EXCEL 2010 - Functions
Average of the selected values

Students of the class accomplished certain grades in specific subjects. Calculate the averages of values by each subject.


 

 

A

B

C

D

E

F

G

H

1

 Class Subject Grade          

2

 II 1 Physics 3,25     Sum Number of the class Average

3

 II 1 Chemistry 3,12   Physics =SUMIF($B$2:$B$11;E3;$C$2:$C$11) =COUNTIF($B$2:$B$11;E3) =F3/G3

4

 II 2 Chemistry 4,02   Chemistry =SUMIF($B$2:$B$11;E4;$C$2:$C$11) =COUNTIF($B$2:$B$11;E4) =F4/G4

5

 II 3 Physics 3,91   Biology =SUMIF($B$2:$B$11;E5;$C$2:$C$11) =COUNTIF($B$2:$B$11;E5) =F5/G5

6

 II 1 Biology 3,62          

7

 II 3 Biology 2,89          

8

 II 2 Physics 4,03          

9

 II 3 Chemistry 3,93          

10

 II 2 Biology 3,18          

11

 II 4 Physics 2,95          

 

Picture 1. Results by subject

Picture 2. Average of the selected /FUNCTION SUMIF/

 

Average of the selected values, steps:

  1. Calculate the sums >>.
  2. Count the number of appearances >>
  3. Select cells;
  4. Equal =
  5. Select the cell with the sum.
  6. Operator /
  7. Select the cell with the number of the class
  8. Enter button (ending the work on the formula) .
  9. Use the marker for remaining values.
  10. The end (Kraj).

Functions    Index