How to count numbers in Excel

Microsoft Excel offers a very interesting way to count numbers. We can cater to this problem statement by using the “COUNTA()” function. We can perform the below mentioned way to count numbers in excel:

We’ll learn about this methodology step by step.

To do this yourself, please follow the steps described below;

Step 1 – Excel sheet with some random numbers

– Open the desired Excel workbook containing some random numbers maybe spaced out in a column

Step 2 – Writing the formula

– Now go to a cell in another column and then type “=COUNTS(“ and now go to the column containing the numbers and press “CTRL + SPACEBAR” on your keyboard and then hit Enter.

Step 3 – Numbers counted

– We can see the total numbers present as shown in the image above.