
Math Formula and Supporting Features 
Return to Top 
Return to Top 
Return to Top 
Return to Top 
Return to Top 
"Or" operation
"And" operation 
Return to Top 
Return to Top 
Using "count_If( )"
Syntax count_if( C1:Cn, "if") C1:Cn is the range of cells you want to evaluate. For example, C1:Cn can be written as R1C1:R1C4 or R1C1, R1C2, R1C3, R1C4. "if" is the criteria that defines which cells will be counted. It be a number or text, for example "=32", "29<=", "pencils" (double quotes are required) or a formula e.g. sin(R1C2). When searching for strings, the "*" can be used as wildcard.

Example
(1) Suppose R1C1:R1C4 contain the following data: 100, 200, 300, 400.
(2) Suppose R1C1:R1C4 contain the following text: aaa, abc, ccc, ddd.
(3) Suppose R1C1:R1C4 contain the following data: 100, 200, 300, 400.

Return to Top 
Return to Top 
Return to Top 
Return to Top 
Return to Top 
Return to Top 
Return to Top 
Return to Top 