There could be times when you have a huge range of cells in a column or multiple columns and you need to count the number of entries in all the cells put together. You can do this using one formula itself instead of using many count formulae together.
Count Cells with Numbers (COUNT FUNCTION)
The COUNT function counts the number of cells that contain numbers & ignores any text. The COUNT function is used to get the number of entries in a number field that is in a range or array of numbers.
Syntax
COUNT(value1, [value2], ...)
The COUNT function syntax has the following arguments:
value1 Required. The first item, cell reference, or range within which you want to count numbers.
value2, ... this is optional & we can have up to 255 additional items or cell references to count numbers.
The arguments (e.g. value1) can be cell references, or values typed into the COUNT formula.
Count Cells with Data (COUNTA FUNCTION)
The COUNTA function will count cells that are not empty.
Its syntax is: =COUNTA(value1, value2,...)
The arguments (e.g. value1) can be cell references, or values typed into the formula.
Count Blank Cells (COUNTBLANK FUNCTION)
The COUNTBLANK function will count cells that are empty.
Its syntax is: =COUNTBLANK(range)
Count the number for Rows
Lets consider we have data in the range A2:A10.
We need to count the number of values in this range. In cell C2, put this formula –
=COUNT(A2:A10)
We get the result as 9.
Count the number for Columns
Here, the data was present in a column. Similarly, if we have data in one row, like this –
We can enter the formula in C4 as –
=COUNT(C2:K2)
The result we get is 9 again.
Count the number for Rows and Columns
Now, if we have a bigger range of data, covering multiple rows and columns, for example, consider that we have data in the range A1:E20 –
We need to count the values in this range. All we need to do is, put this formula in a blank cell in the sheet –
=COUNT(A1:D20)
The result we get is 80 which is the count of all the cells in A1:D20.
Now if we remove the values from some cells, this number will automatically get updated and show us the current value.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.