A alfa Jan 14, 2010 #1 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:
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 Jan 14, 2010 #2 =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
=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
