web analytics

USING THE COUNT AND COUNTA FUNCTIONS IN MICROSOFT EXCEL 2010

Microsoft Excel 2010

This article will show you how to use the COUNT and COUNTA functions in Microsoft Excel 2010. The COUNT function counts the number of cells that contain numbers and the COUNTA function counts the number of cells that are not empty.

There are five types of things that you can put in a cell:

  • Logical value
  • Number
  • Error
  • Formula
  • Words

1

1. Now let’s see how the COUNT function counts the examples of the previously defined types of things that you can put in Excel. In the cell where you want to type the formula just write this =COUNT(highlight all the cells that you want to count) and click the Enter button.

2

Note: In this case the result will be 1, because in this example I only used a number in one cell, the second one.

3

2. Now the COUNTA function gives a different result because it counts all the cells that have something written in it regardless of the type of inserted value. So, now just write the function in the designated cell where you want to count some cells and write COUNTA(highlight all the cells that you want to count).

4

Note: In this case the result will be 5, even though cell number 3 looks empty, it has a formula written in it that gives a blank value as a result, but never the less it counts it as well.

5

Leave a Reply