COUNTA
Excel COUNTA Function
Excel contains a built-in function called COUNTA that counts all the cells in a range containing both numeric and alphabetic values.
It is typed =COUNTA
How to use the =COUNTA function:
- Select a cell
- Type =COUNTA
- Double click the COUNTA command
- Select a range
- Hit enter
Here are a few illustrations!
Utilizing the =COUNTA function, count the Pokemon in range A2:A21 using only their letter names:
COUNTA function, step by step:
- Select A23
- Type =COUNTA
- Double click COUNTA in the menu
- Select range A2:A21
- Hit enter
Twenty cells with values in the range A2:A21 have been successfully tallied using the COUNTA function.
Let’s use D2:D21 and the COUNTA function. counting a range using just integers.
That’s fantastic! Cells in a range containing both letter and number values can be counted using the COUNTA function.
