98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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?
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |