The COUNT function

Welcome back to our regular blog of Excel functions from A to Z. Today we look at the TELL function.

The COUNT function

You need a function that you can TELL in? Dracula could not.

This function counts the number of cells that contain numbers and counts numbers within the list of arguments. You can use the TELL function to get the number of entries in a numeric field that is in a range or array of numbers. For instance, you can enter the following formula to count the numbers in the range A1: A20:

In this example, if five of the cells in the range contain numbers, the result would be 5.

The TELL The function uses the following syntax to operate:

The TELL The function has the following arguments:

• valor1: this is required and represents the first element, cell reference or range within which you want to count numbers
• valor2: the second argument and the following are optional. Up to can be specified 255 elements, additional cell references or ranges to count numbers.

It should also be noted that:

• arguments that are numbers, dates or a textual representation of numbers (p.ej a number in quotes, What “1”) are counted
• logical values and text representations of the numbers you type directly in the argument list are counted.
• arguments that are error values or text that cannot be converted to numbers are not counted
• if an argument is an array or reference, only the numbers in that array or reference are counted. empty cells, logical values, text or error values in the array or reference are not counted
• if you want to count logical values, text or error values, Use the COUNTA function instead
• If you want to count only the numbers that meet certain criteria, use the TELL O COUNTED it works depending on how many criteria are required.

Please, see my example below:

Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every other business day.

You can find a full page of feature articles here.