Manuals/calci/COUNTIF

From ZCubes Wiki
Revision as of 20:32, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  '''COUNTIF (R, C)''' '''Where r is the range of cells and c is the criteria in the form of a number, expression,...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

COUNTIF (R, C)

Where r is the range of cells and c is the criteria in the form of a number, expression, cell reference, or text.

This function calculates the number of cells within a range.

COUNTIF

Syntax
Examples
Description

Lets see an example,

COUNTIF(R,C)

B              C

'

P             50

Q             65

R             90

P            151

=COUNTIF(B2:B5,"P") is 2

=COUNTIF(C2:C5,">66") is 2

Column1 Column2 Column3 Column4
Row1 P 50 2
Row2 Q 65 2
Row3 R 90
Row4 P 151
Row5
Row6
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/COUNTIF&oldid=330"