Page 70 - Penta Book's ICT Catalogue

COUNTIF

If you have a table and you
want to find out how many cells 1

have a value of more than 60,
then you can use the COUNTIF
function.

To use the COUNTIF
function: 2
> Click the cell you want to
add your function to, in this
example, cell B9. 3

> On the Formulas tab in the
Function Library group,
click Insert Function. 1
> In the Or select a 4
category list, click
Statistical. 2
> Click COUNTIF. 3 5
> In the Function DIGITAL TEENS 2 MODULE 5
Arguments window, in the Computing and ICT . Sample Pages
Range box,
type B3:C7 and in the
Criteria, type >=60. 4
> Click OK. 5
8
GRADE

hands on!

Type the following table and fill in the cells with the

appropriate functions. In cell I3 use the AND function to check
if cells C3 to E3 have values
less than or equal to 75 and

in cell H3 to find out how
many cells have a value of
more than 65.

Penta Books 69