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 » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2007
RE: Excel
Hello Calvin
Thank you for your question and welcome to the forum.
There are several ways to count items in Excel.
You can use COUNT or COUNTA functions:
=COUNT(cell range) or =COUNTA(cell range)
COUNT will tell you how many numbers (values) there are in the cell range in the brackets; COUNTA will tell you how many cells contain something (can be text or numbers).
So these can be used to answer 'how many' questions.
You can also use COUNT without entering a function - select the cell range and then right-click on your status bar at the bottom of the screen, and select Count to display how many numbers are in the range you selected.
COUNTIF will count specific instances of something within a cell range:
=COUNTIF(cell range, criteria).
For example, if I wanted to know how many times the number 1 appeared within the range B5:B20 I would enter:
=COUNTIF(B5:B20,1)
I hope this helps.
Amanda
Mon 15 Dec 2008: Automatically marked as resolved.
Training information:
See also:
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. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |