Susan, re COUNT: is this what you're looking for? Excel V5a
GM
COUNT
Counts how many numbers are in the list of arguments. Use COUNT to get the number of entries in a number field in a range or array of numbers.
Syntax
COUNT(value1, value2, ...)
Value1, value2,... are 1 to 30 arguments that can contain or refer to a variety of data types, but only numbers are counted.
Arguments that are numbers, null, logical values, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.
If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
Examples
If A3 contains "Sales," A4 contains "12/8/90," A6 contains "19," A7 contains "22.24," and A9 contains "#DIV/0!", then:
COUNT(A6:A7) equals 2
COUNT(A4:A7) equals 3
COUNT(A2, A6:A9, "Twelve", 5) equals 3
COUNT(A1:A9, , "2"), where "2" is a text representation of a number, equals 5
COUNT(0.1, TRUE, "three", 4, , 6.6666, 700, , 9, #DIV/0!) equals 8
Related Functions
AVERAGE Returns the average of its arguments
COUNTA Counts how many values are in the list of arguments
DCOUNT Counts the cells containing numbers from a specified database and criteria
DCOUNTA Counts nonblank cells from a specified database and criteria
SUM Adds its arguments
List of Statistical Functions |
