abc MICROSOFT EXCEL 2010 - Functions
Function SUMIF - Average

Students of the classes accomplished certain goals in each subject. Calculate the sum by each subject and look at the following animation, and for the number of the class (look at the animation >>) and for Averagee (look at the animation >>).
 


 

 

A

B

C

D

E

F

1

 Class Subject Grade      

2

 II 1 Physics 3,25     Sum

3

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

4

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

5

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

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. Function SUMIF

 

Function SUMIF - Average, steps:

  1. Select an empty cell;
  2. Type =SUMIF.
  3. Define the area.
  4. Absolute adressing the range ($) is done by pressing the functional button
  5. Select the desired value.
  6. Select the range /RANGE/ of values (in this caseGrade).
  7. Enter button (ending the work on the formula) .
  8. Use the fill marker for remaining values.
  9. The end (Kraj).

Functions /Functions/    Index