Topic 27: Count...Count...Count...What you can do with Excel 2007 COUNT Function

[seema]

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:
  
  
• Click on the cell C9.

Similar Threads:

• Topic 19: Do You Really Know the Excel 2007 Function?
• Topic 23: Using COUNT() Function in Excel
• You Need To Count And Cloak Affiliate Links
• Does Google PageRank Count Anymore?
• What is A, B, C and D Indicator for a material for cyclic count?

[seema]

• 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.
• 
  
  
• 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.

[seema]

• Repeat the above process for the cells D9 and D10 to get the results.