Excel 2007 COUNTA Function

Related article: Excel 2003 COUNTA Function

Excel’s COUNTA function is one of a group of “Count Functions” that can be used when you need to total the number of cells in a selected range.

The COUNTA function's job is to add up the cells in a selected range that contain numbers, dates, or text labels. It ignores empty cells. If data is later added to an empty cell the function will be automatically updated to include the addition.

The syntax for the COUNTA function is:

= COUNTA ( Value1, Value2, ... Value255 )

Up to 255 values can be entered into the function.

Example Using Excel 2007's COUNT Function:

Note: For help with this example, see the image to the right.

1. Enter the following data into cells C1 to C6: A , B , C , D , E , F.
   
   
2. Click on cell C7 - the location where the results will be displayed.
   
   
3. Click on the Formulas tab.
   
   
4. Choose More Functions > Statistical from the ribbon to open the function drop down list.
   
   
5. Click on COUNTA in the list to bring up the function's dialog box.
   
   

6. Drag select cells C1 to C6 on the spreadsheet to enter the range into the dialog box.
   
   
7. Click OK.
   
   
8. The answer 6 should appear in cell C7.
   
   
9. The complete function = COUNTA ( C1 : C6 ) appears in the formula bar above the worksheet.

• Excel 2003 COUNTA Function
• Excel 2007 COUNTIF
• Excel 2007 COUNTBLANK