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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Assistance with Fomula 0
Automatically Pulling Cells from Different Tabs and Files 1
What 'value' is a Dec2Bin output? 9
Excel Need Countifs Formula Help 0
VLookup and Sum If formula 3
A function to Turn Formula into Text? 24
Add Subtotal functions using cell references 2
Excel formula 4

Top