# Count cells that contain numbers

Let's say you want to count only rows that contain numbers and dates in a column that contains a mix of different data types. There are several ways to count cells that contain numbers.

### What do you want to do?

Count cells that contain numbers in a contiguous row or column

Count cells that contain numbers that are not in a contiguous row or column

## Count cells that contain numbers in a contiguous row or column

1. Select a cell below or to the right of the numbers that you want to count.
2. Click the arrow next to the AutoSum on the Standard toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), and then click Count and press ENTER.

## Count cells that contain numbers that are not in a contiguous row or column

To do this task, use the COUNT function.

## Example

The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic.

Note   Do not select the row or column headers.

Selecting an example from Help
1. Press CTRL+C.
2. In the worksheet, select cell A1, and press CTRL+V.
3. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
A
Data
Sales
12/8/2007
19
22.44
Formula Description (Result)
=COUNT(A2:A6) Counts number of cells that contain numbers (3) in the list. A date is a number.
=COUNT(A2:A3,A6) Counts number of cells that contain numbers (2), of the top two and bottom cells in the list. A date is a number.

COUNT

Applies to:
Excel 2003