Counting specific values

[JodiEHBK]

I need a formula to count specific values in a range of data. For example, say I have the values 0, 1, 2 and 3 in a column and want to know how many "1's" are in the column. I have experimented with combinations of IF and COUNT and DCOUNT without success.

It would be helpful if I can count specified text entries as well as numerical values.

Can anyone help?

 

[Joe4]

Try the COUNTIF function. See Excel's help for details.

 

[Lewiy]

=COUNTIF(A:A,1)
will tell you how many 1's in column A

=COUNTIF(A:A,"text")
will tell you how many cells contain "text" in column A

Hope that helps!

 

[JodiEHBK]

Wow, that problem was quickly solved. Many thanks, jm14 and Lewiy. COUNTIF does the what I want perfectly.

 

[Ahonymus]

I'm using Excel 2003 in French and cannot find the function COUNTIF.
I'm trying to count the cells with nothing in there in ONE column. Everything I've tried says "circular"

If someone could help solving my request... Thanks a lot.

 

[Aladin Akyurek]

I'm using Excel 2003 in French and cannot find the function COUNTIF.
I'm trying to count the cells with nothing in there in ONE column. Everything I've tried says "circular"

If someone could help solving my request... Thanks a lot.

It's:

NB.SI

One of:

=NB.SI($A$2:$A$10;"")

=NB.SI($A$2:$A$10;"=")