"Excel 2007 Count Function - Excel Count Function Example"


Excel 2007 Count function is to calculate the number of entries in a range of cells (list of arguments). It counts only the numeric values and excludes the text values, dates, and logical values.

The syntax for the Count function:

=COUNT (value1[,value2,...]) whereby

value1, value2,... is one or more ranges, arrays, function results, expressions, or literal values of which you want the count.


To demonstrates the use of the Count function

  • Create a spreadsheet as follow:
  • Excel 2007 Count function worksheet

  • Click on the cell C9.
  • From the Formula tab, in the Function Library group, click the More Functions icon and point to Statistical from the drop down menu, click the COUNT command.
  • Excel 2007 Count function arguments

  • From the Function Arguments dialog box displayed, enter C4:C8 in the Value1 entry. The Count function will calculate the number of occurrences in the range from C4 to C8.
  • Click OK.
  • Repeat the above process for the cells D9 and D10 to get the results.

Excel 2007 count function results


Related Topics:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
How to Use the Cell Function in Microsoft Excel 2007?
Guide to Use the NOW Function Correctly in Excel 2007
Demonstration of Using the Date and Time Functions with Excel 2007
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Guide to Use the Excel 2007 Radian Function Correctly



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

Custom Search


Back to Top

You're viewing the Excel 2007 Count Function info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007





XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.