Prev: where can I find a template for church inventions
Next: Notify of Replies
From: alfa on 14 Jan 2010 08:01
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:

From: Bernard Liengme on 14 Jan 2010 08:10
=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" <alfa(a)discussions.microsoft.com> wrote in message
news:CC82E892-B73B-4B58-9797-19B3E09894EE(a)microsoft.com...
> 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:
>
 | 
Pages: 1
Prev: where can I find a template for church inventions
Next: Notify of Replies