# Excel COUNT Function

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.

**value1**- An item, cell reference, or range.**value2**- [optional] An item, cell reference, or range.

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.