99.4% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
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
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
How do you use Count A
Pauline Enter a zero 0 day in the duration part of the task
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?
What is the difference between count - countA?
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.