Count a certain value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to count how many times the number 2 (for example) is in a column.

There must be some type of COUNT function (like count nonblank cells that
contain the value "2", like an ACOUNT) but I can't find it and he help
doesn't show me.

Thanks!
 
Try this:

=COUNTIF(A1:A100,2)
or
=COUNTIF(A1:A100,B1)

where B1 contains the number you are interested in.

Hope this helps.
 

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

counta function can any one explain the example counting 2 4
How to count interstitial blank cells? 3
Count no. of nonblank cells in one column based on criteria of ano 9
Count the columns from one sheet and paste it in another sheet 0
Summarizing a count of like values 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting Ranges 2
Counting Occurances (2003) 2

Back
Top