Please help! I am trying to create a formula that will give me a total of
the x's in a column.
Niek Otten - 07 Nov 2006 17:21 GMT
Look in HELP for COUNTIF()

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Please help! I am trying to create a formula that will give me a total of
| the x's in a column.
George Gee - 07 Nov 2006 17:23 GMT
=COUNTIF(A1:A100,"x")
George Gee
> Please help! I am trying to create a formula that will give me a total of
> the x's in a column.