Home
MS Office - How to ?
Win Vista Training
Windows 7 Tutorials
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Outlook Tutorials
Excel 2007 Tutorials
Word 2007 Tutorials
PowerPoint 2007 Tutorials
Office 2007 Training
Office 2007 Videos
Free E-Books
Free Templates
Free Clip Arts
Tips and Tricks
Office 2010 Tips
Google Docs and ...
MS Office Software
MS Publisher
Site Map
Contact Us
Resources Page

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines
 


Excel COUNT Function


Excel COUNT function will return the number of entries (actually counts each cell that contains number data) in the selected range of cells.

Text and blank entries are not counted. If number data is later added to an empty cell in the range, the count total is automatically updated.

The syntax for the function is:

=COUNT(argument)
Argument is the range of cells to be totaled.

To use the COUNT function (an example)

  • Enter the following data into cells B1 to C6:

    Excel COUNT function data



  • Click on cell C7 where the results will be displayed.
  • Type =COUNT(B1:C6) in cell C7.
  • Once finish, press the Enter key on the keyboard.
  • The answer 12 appears in cell C7.

    Note: Since dates, times, and formulas are stored as numbers in Excel, the COUNT function will include any cells containing these types of data in the total.


    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    >> Next Topic : The AVERAGE( ) Function Can use to Calculate...
    << Previous Topic : Use Excel MAX( ) Function to Find the Largest Number in a List


    You're viewing the Excel COUNT function info page, click here to go back to the Home Page


    footer for count function page

    		•