Excel count (number function)

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:


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

Read forum post


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

Read forum post



How do you use Count A

Read forum post


RE: milestone

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

Read forum post



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?

Read forum post


Excel intro

What is the difference between count - countA?

Read forum post



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.

Server loaded in 0.09 secs.