excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · High Priority · Version 2007

Calvin has attended:
Excel Intermediate course

Excel

How do I add autocounts

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.


 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, 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.

View all Excel hints and tips


Server loaded in 0.09 secs.