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

EXCEL has a posibility to pick out based on the relational operator. Counting bigger (e.g. 2) and smaller (e.g. 8) is presented 


 

 

A

B

C

D

1

 5      

2

 4      

3

 2      

4

 5   <8 =COUNTIF($A$1:$A$10;C4)

5

 8   >2 =COUNTIF($A$1:$A$10;C5)

6

 4      

7

 2      

8

 1      

9

 4      

10

 3      

11

        

 

Picture 1. Results by subject

Picture 2. Summing the selected /FUNCTION SUMIF/

 

Function COUNTIF - Counting the selected values - Relational operator, 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 (see Picture 2).
  8. The end (Kraj).

Functions    Index