Excel COUNT function

Summary

The Excel COUNT function is a fundamental tool designed to count the number of cells that contain numbers within a specified range. It’s particularly useful for quickly assessing the volume of numeric entries in large datasets, making it invaluable for data analysis, inventory tracking, and in situations where numerical data points are crucial.
Syntax
				
					=COUNT(value1, [value2], ...)
				
			
  • value1: The first item, cell reference, or range to count
  • value2, …: [Optional] Additional items, cell references, or ranges to count, up to 255 arguments
Return value
The number of cells that contain numbers.

How to use

To use the COUNT function, input the range of cells you wish to count. The function will automatically tally the number of cells within this range that contain numeric values, ignoring any cells with text, blanks, or non-numeric data.

Examples

Simple COUNT
To Count Numeric Entries in a Column: Assuming A1:A10 is filled with various data types including numbers, text, and blanks.
				
					=COUNT(A1:A10)
				
			
If A1:A10 has four numbers (2, 4, 6, 8) and six non-numeric entries (text or blanks), COUNT would return 4, representing the total count of numeric entries.
COUNT for Multiple Ranges
Counting Across Several Ranges: When you want to tally numeric entries across different data blocks.
				
					=COUNT(A1:A10, C1:C10)
				
			
Assuming A1:A10 contains five numbers and five blanks, and C1:C10 contains three numbers and seven blanks, the formula would yield 8 as the total count of numeric cells across both ranges.
COUNT with Individual Cells
Including Individual Cells in the Count: To selectively count numeric entries in non-adjacent cells.
				
					=COUNT(A1, A3, A5)
				
			
If A1 contains the number 10, A3 is empty, and A5 has the number 20, the result of this formula would be 2, counting only the cells that contain numbers.
COUNT for Mixed Data Types
Evaluating Numeric Presence Among Diverse Data: To ascertain the number of numeric entries within a dataset comprising various data types.
				
					=COUNT(A1:B10)
				
			
If the range A1:B10 includes eight numbers, one text entry, and one blank cell, COUNT will return 8, focusing solely on cells that contain numeric data.

Additional Notes

  • COUNT exclusively counts cells with numeric data; it does not consider cells containing text, errors, blanks, or logical values (TRUE/FALSE).
  • For a broader count that includes any type of data (numbers, text, errors, logical values, and even blanks), consider using the COUNTA function.
  • Utilize COUNTIF or COUNTIFS for counting based on specific criteria, offering more flexibility in identifying and tallying cells that meet particular conditions.

Related Functions

Excel COUNTIFS function

The Excel COUNTIFS function counts cells meeting multiple criteria, essential for complex data categorization.

Excel COUNTBLANK function

The Excel COUNTBLANK function counts empty cells in a specified range, useful for identifying gaps in data sets.

Excel COUNTIF function

The Excel COUNTIF function counts cells that meet a single condition, vital for targeted data quantification.

Excel COUNTA function

The Excel COUNTA function counts non-empty cells, crucial for assessing the extent of data in a range.

Content Navigation