keep in mind javascript is needed for full functionality of the web portal.
Welcome back to our usual blog of Excel functions from A to Z. Today we look at the COUNTA function.
The COUNT function
This is not Italian TELL nor a function or an Excel calculator dedicated to counting the number of times a letter appears “a” in a spreadsheet. This function actually counts the number of cells that are not empty in a range. I suppose COUNTNOTBLANK is too clumsy, but it is not entirely correct either (look down).
The COUNTA The function uses the following syntax to operate:
TELL (valor1, [value2], …)
The COUNTA 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 items, additional cell references or ranges to count numbers.
It should be noted at the same time that:
- The COUNTA The function counts cells that contain any type of information, including error values and empty text (“”). As an example, if the range contains a formula that returns an empty string, the COUNTA the function counts that value. This is different behavior from the COUNTBLANK function that considers empty text as blank, In other words COUNTA (rank) + COUNTBLANK (rank) it is not necessarily equal to the number of cells in the encompass, that many modelers assume as an identity
- The COUNTA la función no cuenta las celdas vacías
- Si no necesita contar valores lógicos, text or error values (In other words, si desea contar solo las celdas que contienen números), use el TELL function
- Si desea contar solo las celdas que cumplen con ciertos criterios, use el 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 the feature posts here.
