COUNT is an excel formula that is used, as suggestive it can be, to count, the number of cells in a range that have numbers in a given/selected range. It can be used to count numbers in columns, rows or in multiple selected cells.
Below are examples of the simple usage of the COUNT formula. In Formula Bar, you will be able to see the COUNT formula that is used.
Example for Columns:
Explanation: In the above instance, we have used the formula to count the number of cells that contain numbers in column B from Cell B2 to B5. The COUNT formula used here is =COUNT(B2:B5). The Count formula ignores the text the range and gives you the count of numbers in the range.
Example for Rows:
Explanation: In the above instance for using COUNT in rows, we have used the formula to count the number of cells that have numbers in Row 2 from Cell B2 to G2. The COUNT formula used here is =COUNT(B2:G2)
Example for selected cells:
Explanation: In this instance for using COUNT for selected cells, as the values are not in same columns or rows, we have we have used the formula COUNT by giving cell reference to the selected cells which are separated by a comma. The COUNT formula used here is =COUNT(A3,B6,C4,D3).
Please leave a comment if you have any questions on this.