formula

A

alfa

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:
 
B

Bernard Liengme

=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
 
Top