Exceljet

Quick, clean, and to the point

Excel COUNT Function

Excel COUNT function
Summary 

The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.

Purpose 
Count numbers
Return value 
A number representing a count of numbers.
Syntax 
=COUNT (value1, [value2], ...)
Arguments 
  • value1 - An item, cell reference, or range.
  • value2 - [optional] An item, cell reference, or range.
Usage notes 

The COUNT function counts the number of numbers in supplied values. Values can be items, cell references, or ranges. For example, =COUNT(1, 2, "apple") returns 2. And COUNT(A1:A10) will count the number of numeric values in the range A1:A10.

  • Count can handle up to 255 additional values.
  • Use COUNTA to include text and logical values. Use COUNTIF to count based on criteria.
  • Error values or text values that cannot be coerced into numbers are not counted
  • The logical values TRUE and FALSE are not counted.
  • Empty cells and text are not counted.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.