Count cells for certian data

A

andespoint

Hi guy's i have a spreadsheet with a column that can contain an F or COL. I
want to count how many of each I have and display the info in another cell.
Would anyone know how to do this using a formula/function?

Thanks for any help.
 
R

Ragdyer

Say the column containing the data was Column A, then try these in a cell in
any other column:

=Countif(A:A,"F")
=Countif(A:A,"COL")
 
R

Ron Rosenfeld

Hi guy's i have a spreadsheet with a column that can contain an F or COL. I
want to count how many of each I have and display the info in another cell.
Would anyone know how to do this using a formula/function?

Thanks for any help.
Click to expand...

Look at HELP for the COUNTIF worksheet function.
--ron
 
A

andespoint

Thanks for the great information and Help.


Ragdyer said:
Say the column containing the data was Column A, then try these in a cell
in any other column:

=Countif(A:A,"F")
=Countif(A:A,"COL")
Click to expand...
 
Top