BET: Microsoft Excel Functions

Excel

Returns the number of numeric values in a list or cell range.

	value1	The first value.
	value2	The second optional value.

REMARKS

		This function includes hidden rows.
		Arguments that are numbers, dates, or text representations of numbers are counted.
		Arguments that are text, logical values or errors are ignored.
		Arguments that are empty cells are ignored. See Example 5.
		If an argument is an array or reference, only numbers in that array or reference are counted. See Example 11.
		Use this function to get the number of entries in a number field in a range (or array) of numbers.
		Dates and formulas that evaluate to numbers will be included.
		You can have a maximum of 30 arguments.
		If you do not want to count any arguments that are text, logical values or errors you can use the COUNTA() function.
		FORMATCOUNT() - Returns the number of cells that have a particular format.
		Example 1 -
		Example 2 -
		Example 3 -
		Example 4 -
		Example 5 -
		Example 6 -
		Example 7 -
		Example 8 -
		Example 9 -
		Example 10 -
		Example 11 -

EXAMPLES