abc MICROSOFT EXCEL 2010 - Functions
Counting the selected values - Function COUNTIF

Function COUNTIF is a statistical function.

Members of teams 1 and 2 won points according to the table. Count how many points each team won individually.


 

 

A

B

C

D

1

 Pero Team 1 5  

2

 Mika Team 2 4  

3

 Laza Team 1 3  

4

 Dule Team 2 2  

5

 Bane Team 2 2  

6

 Rale Team 1 1  

7

        

8

     Team 1 =COUNTIF(B2:B7;C9)

9

     Team 2 =COUNTIF(B2:B7;C10)

 

Picture 1. Results of the summing /FUNCTION SUMIF/

Picture 2. Counting the selected/FUNCTION SUMIF/

 

Counting the selected values - Function COUNTIF, steps:

  1. Select the cells D9 (Team 1).
  2. Type =COUNTIF.
  3. Define the area.
  4. Select the desired value (Team 1).
  5. Enter button (ending the work on the formula) .
  6. Select the empty cell D10 (Team 2).
  7. Type =COUNTIF.
  8. Define the area.
  9. Select the desired value (Team 2).
  10. Enter button (ending the work on the formula).
  11. The end (Kraj).

Functions    Index