writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 10:
Line 10: − + + Line 19:
Line 20: +
no edit summary
COUNTA(v1,v2....)
COUNTA(v1,v2....)
Consider columns A1 to A8 contain 3 numbers. Then, the function COUNTA(A1:A8) ''returns 3 '' as a result.
Consider columns A1 to A8 contain 3 numbers. COUNTA(A1:A8) ''returns 3 '' as a result.
COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
COUNTA((A1:A8),"SUN",13) ''returns 5'' as a result.
* COUNT() can be used to count the number of cells of all type of values excluding logical values, text and error values.
* COUNT() can be used to count the number of cells of all type of values excluding logical values, text and error values.
* COUNTIF() can be used to count the number of cells that satisfy the given criteria.
<!--
<!--
</div>
</div>