writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − − + − − Line 10:
Line 7: − + − + − + − + − − − − − − −
no edit summary
=COUNTA ()=
<div style="font-size:30px">'''COUNTA ()'''</div><br/>
*Parameters are any arguments.
*Parameters are any arguments.
**COUNTA(), counts how many values are in the list of arguments.
*COUNTA() returns the count of non-empty cells, and values within the list of arguments.
*Empty cells and text values in the array or reference are ignored.
*Empty cells and text values in the array or reference are ignored.
COUNTA()
COUNTA()
Consider columns A1 to A8 contain 3 numbers. 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.
*COUNTA(1..100,5,TRUE) ''returns 102'' as a result. Logical value 'TRUE' is also counted.
*COUNTA(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
COUNTA(1..100,5,TRUE) ''returns 102'' as a result. Logical value 'TRUE' is also counted.
COUNTA(1..100,5,TRUE,"ONE") ''returns 103'' as a result.
* Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").
* Arguments can be numbers, dates, text representation of a numbers, logical values, error values or empty text("").
* Empty cells and text values are not counted.
* Empty cells and text values are not counted.
* 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.
* COUNTIF() can be used to count the number of cells that satisfy the given criteria.