I have a column that contains either numbers or the letters. I need a worksheet formula that will sum how many letters the column contains.
	I need to use the COUNTIF function to count the number of cells in range J1:J100 that are greater than the value in cell A1, but I can't seem to make it work. Is this possible?
	I have a column of data that itemizes a person's sex with M or F, is there a function that will count the number of each in the column?

I have a column that contains either numbers or the letters. I need a worksheet formula that will sum how many letters the column contains.
Keywords: Functions, Sum, Count
Posted December 6, 1996

Assume that your data is in range A1:A10. You can do this with a combination of the COUNTA and the COUNT functions as follows:

	=COUNTA(A1:A10)-COUNT(A1:A10)

The COUNTA function returns the total number of non-blank values in the range. The COUNT function returns the total number of numeric values in the range. The difference between these two numbers is a count of the letters in the range.

I need to use the COUNTIF function to count the number of cells in range J1:J100 that are greater than the value in cell A1, but I can't seem to make it work. Is this possible?
Keywords: Functions, COUNTIF
Posted December 6, 1996

Very possible, you just need to concatenate cell A1 onto the COUNTIF criteria argument like so:

	=COUNTIF($J$1:$J$100,">" & A1)

I have a column of data that itemizes a person's sex with M or F, is there a function that will count the number of each in the column?
Keywords: Counting, Functions
Posted December 6, 1996

The COUNTIF function is what you're looking for. Let's say you have data indicating male (M) and female (F) in range A1:A10. To count the number of males in this list you would use:

	=COUNTIF(A1:A10,"M")

and to count the females it would be:

	=COUNTIF(A1:A10,"F")

Back to Top

Back to the FAQ Table of Contents

For people who like peace and quiet: a phoneless cord.