Syntax
=COUNTA(value1, [value2], ...)Arguments
| Argument | Required | Description |
|---|---|---|
value1 | Required | A value, cell or range to count |
value2 | Optional | More values or ranges |
How to use COUNTA
COUNTA takes 1 required argument and 1 optional argument, and accepts more values in the same pattern. Type =COUNTA( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=COUNTA(1, "x", TRUE)Result =COUNTA(A1:A4)Result Data in the sheet
| A | |
|---|---|
| 1 | 5 |
| 2 | text |
| 3 | |
| 4 | TRUE |
Related statistical functions
- CONFIDENCE.NORMReturns the margin of error of a population mean using a normal distribution.
- CONFIDENCE.TReturns the margin of error of a population mean using Student's t distribution.
- CORRELReturns the correlation coefficient of two sets of numbers.
- COUNTCounts how many numbers are in a list or range.
- COUNTBLANKCounts the empty cells in a range, including cells holding empty text.
- COUNTIFCounts the cells in a range that meet a condition.
- COUNTIFSCounts the cells that meet all of several conditions.
- COVARIANCE.PReturns the population covariance of two sets of numbers.
- COVARIANCE.SReturns the sample covariance of two sets of numbers.