=COUNTIF(A:A,"X")
will count how many cells in column A have the value X

or
=COUNTIF(A1:A1000,"Apple")
will count how many times the word Apple appears in cells A1:A1000

Note that this is not case sensitive, so apple, Apple
--
best wishes
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme and APPLE all get counted


"alfa" wrote in message
...
I am trying to create an IF formula. Example wherever if i will type in
excel
sheet same name "X"1000 cells.I want show one cell 1000: