COUNT Formula Excel / How to use COUNT Function in MS Excel.

COUNT Formula with Example in Microsoft Excel / How to use COUNT Formula in MS Excel / Microsoft Excel (MS Office) COUNT Function / Formula.

In MS Excel, COUNT Formula is a very important formula. Every Excel user should have knowledge / information about COUNT Function. What exactly COUNT Formula do in Excel or How to use COUNT Formula in MS Excel with Example?

COUNT Function or COUNT Formula counts the number of cells in a range that have numbers in them. If you want to count the number of cells that contains data* (only Numeric Data), then COUNT function / formula is used. COUNT Formula can use in Microsoft Excel 2003, 2007, 2010, 2013 or any version of Microsoft Office MS Excel.

What is the SYNTAX of COUNT Formula in Excel?

SYNTAX:- =COUNT(range) or =COUNT(value1, value2....valueN)

NOTE:- Remember that COUNT Formula in MS Excel Counts only those cells that contain Numbers (Numeric Data).

COUNT Example:-

We have a data and we want to know the count of number cells within the data range. Lets say, We have some data from A2 to A11 (A2:A11) and we want to know the count of cells that contains numbers, then we will use COUNT Formula. See below:-

Count Example

In Example 1, there are two values which are not numbers so COUNT Formula count only 8 rather than 10.

In Example 2, All values are numbers (Numeric values) so COUNT Formula counts complete cells within the range E2:E11.