abc MICROSOFT EXCEL 2010 - Functions
Counting the selected values COUNTIF/ - Average values

Students of the classes achieved certain accomplishments in given subjects. Calculate the number of classes by individual subjects, look at the next animation, and for summing the selected subjects (animation >>.) and averaging the values (animation >>).


 

 

A

B

C

D

E

F

G

1

 Class Subject Grade        

2

 II 1 Physics 3,25     Sum Class number

3

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

4

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

5

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

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. Summing the selected /FUNCTION SUMIF/

 

Counting the selected values /FUNCTION COUNTIF/ - Average values, steps:

  1. Select the cells;
  2. Type =COUNTIF.
  3. Select the area.
  4. Absolute adresess of range ($) are selected by pressing the functional button .
  5. Select the wanted value.
  6. ENTER button(ending the work on the formula) .
  7. Use the fill out marker for other areas (look at Picture 2).
  8. The end (Kraj).

Functions    Index