Count()
COUNT(value1, [value2], …)
count the number of cells contain certain numbers(not text)
COUNTA()
COUNTA(value1, [value2], …)
used to count text(not number)
counts the number of cells that are not empty in a range.
Countblank(range)
is used to count the number of empty cells in a range of cells.
Countif() & Countifs()
=COUNTIF(range, criteria) 可以是数字,也可以是文本
=COUNTIF(Where do you want to look?, What do you want to look for?)
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.
In its simplest form, COUNTIF says:
=COUNTIF(Where do you want to look?, What do you want to look for?)