Excel count (number function)

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Topics » Excel count (number function)

# Excel count (number function)

The Excel count function will calculate how many cells, containing numbers dates or times, appear in a range of cells. Cells that contain text or are blank are not counted.

Should you want to count cells that contain text use the COUNTA function.

For example, if you have number values in all but 2 of a range of cells A1 through to A10, you use the COUNT function which is written as: =COUNT(A1:A10)

The result is 8, since only 8 of the 10 cells are filled in.

The main benefit of using the COUNT function is that it will save you loads of time since you do not have to manually count the cells containing numbers or dates and time.

Imagine manually counting a range which spans 60,000 rows...simply use the Excel COUNT function... it will do the task in a flash!

# Related forum posts:

## COUNT/COUNTA

Can someone please explain the difference between count and counta formulas? Thanks

## Counting items in columns.

Can you please advise the best way to count the number of items which are listed in a column. ( eg a list of names attending a conference?) thanks

## CountA

How do you use Count A

## RE: milestone

Pauline Enter a zero 0 day in the duration part of the task

## Excel

How is the easiest way to Count the number of Items in a list which are words. For example if you had a list of Hotels in London and Edinburgh, how can you easily count the london entries, without putting in an extra column with 1 in it?

## Excel intro

What is the difference between count - countA?

Training courses

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.