Formulas and Functions Help
- Welcome
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Copyright
COUNT
The COUNT function returns the number of its arguments that contain numbers, numeric expressions or dates.
To learn the basics about using formulas and functions, see Formulas overview and Functions overview.
COUNT(value, value…)
value: Any value or a collection containing any values.
value…: Optionally include one or more additional values or collections.
Examples |
|---|
The information in the following table is not meaningful, but is useful to illustrate the type of arguments COUNT includes in its result. Given the following table: |
A | B | C | D | |
|---|---|---|---|---|
1 | 100 | 200 | 300 | 400 |
2 | lorem | ipsum | dolor | sit |
3 | 100 | 200 | 300 | sit |
4 | TRUE | TRUE | FALSE | FALSE |
5 | 200 | 400 |
=COUNT(A1:D1) returns 4, because all arguments are numeric. =COUNT(A2:D2) returns 0, because none of the arguments are numeric. =COUNT(A3:D3) returns 3, because the last cell is not numeric. =COUNT(A4:D4) returns 0, because the arguments are boolean TRUE or FALSE, which are not counted as numeric. =COUNT(A5:D5) returns 2, because two cells are empty. =COUNT(2, 3, A5:D5, SUM(A1:D1), "A", "b") returns 5, because the arguments 2 and 3 are numbers, there are 2 numbers in the collection specified by the range A5:D5, the SUM function returns a number and the last two arguments are text, not numeric (altogether 5 numeric arguments). |
Example — Survey results |
|---|
To see an example of this and several other statistical functions applied to the results of a survey, see the COUNTIF function. |