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

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

CountA

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

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?

Read forum post

Excel intro

What is the difference between count - countA?

Read forum post

Training courses

98.7 % recommend us More live stats...