How to count X's in a column

  • Thread starter Thread starter Marie1uk
  • Start date Start date
M

Marie1uk

Hi,

I need to count the number of X's that appear in column B. What would
the best function be to do this?

Many thanks,

Marie
 
=COUNTIF(B:B,"X")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Countif, index and match 2
Counting Distinct Values 4
SUMIFS ONLY UNTIL the number REPEATS 1
counting formula 3
help with a vlookup 2
Unique entries spread over several columns 7
Formula - find unique entries over several columns 2

Back
Top