How to Use Excel's Count A Function

Excel's Count A function counts the number of non-empty cells and values in a list of arguments. It can also count the cells that contain data in an array or range. The following steps will show how to use Excel's Count A function.

Instructions

Difficulty: Moderate

1. Learn the syntax of Count A. It is Count A (value_1,value_2,…value_n) where value_1,value_2,…value_n are 1 to 30 arguments that contain the values you wish to count.
2. Study which values will be counted by Count A. Values with any information will be counted as long as they do not represent an empty cell, including empty text and error values.
3. Examine how Count A evaluates arguments that are arrays or references. Count A will only consider values that are in these arguments. Empty cells and text values in the array or reference will be ignored. Use the Count function if you do not wish to count error values, logical values or text.
4. Look at some examples of Count A using a cell range as an argument. Set A2=apple, A3=10/7/2007, A4 blank, A5=19, A6=3.14, A7=TRUE and A8=#DIV/0!.
   
   Count A(A2:A8) = 6. A4 is blank and therefore not counted.
   Count A(A5:A8) = 4. All values in this range are counted.
5. Observe examples of Count A that use a cell range and other values as arguments.
   
   Count A(A2:A8,3) = 7. The six non-empty values of A2:A8 are counted with the value 3.
   Count A(A5:A8,"three") = 5. All four values in A5:A8 are non-blank and therefore counted with the value "three."
   Count A(A5:A8,3,"three") = 6. The four non-blank values in A5:A8 are counted along with the values 3 and "three."

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.