Counting occurance of letters or numbers

[Guest]

I am helping some one else .... so excuse the limited and continuation of
questions I may plan to ask.

I have a columns with 1 character entry... in 11 rows

Column A

x
0 This column to the left, I want to count the # of x's,
which is 5 in this
2 example
3
_
x Immediately underneath the answer above
0 I would also like to count the number of time #s 1-7
show up and 0
x needs to be omitted.. this example would be 2... the 2
and 3
_
r Some cells may have NO entry or blank indicated by _
x
x
I am not sure what the "r" is yet... But these
answered above will get me on my way.

Thanks for all the help

 

[Guest]

=COUNTIF(G4:G15,"x") will give you the number of X's anyway......

 

[JulieD]

Hi

to count anything in a range you have the choice of COUNTIF or SUMPRODUCT
both of your requirements can be achieved using COUNTIF

for the "x's"
use
=COUNTIF(A1:A11,"x")

for the number of items between 1 & 7 inclusive use
=COUNTIF(A1:A11,"<="&7)-COUNTIF(A1:A11,">="&1)

Cheers
JulieD

 

[Guest]

In column B, or below your eleven rows in Col A, enter the following formula:
=COUNTIF(A1:A11,"x")

 

[Guest]

It needs an amendment:
=COUNTIF(A1:A11,"<="&7)-COUNTIF(A1:A11,"<="&1)

 

[Guest]

OOops!
Here it is:
=COUNTIF(A1:A11,"<="&7)-COUNTIF(A1:A11,"<"&1)

 

[JulieD]

why?

It needs an amendment:
=COUNTIF(A1:A11,"<="&7)-COUNTIF(A1:A11,"<="&1)

 

[JulieD]

sorry Phil, of course you are correct

It needs an amendment:
=COUNTIF(A1:A11,"<="&7)-COUNTIF(A1:A11,"<="&1)

 

[AlfD]

Hi!

What happens for the value 1? Counted in by te first expression and
counted out by the second.
Suggest second expression changes to COUNTI­F(A1:A11,">"&1 ) i.e.
drop the "="

Alf

 

[AlfD]

Hi!

What happens for the value 1? Counted in by te first expression and
counted out by the second.
Suggest second expression changes to COUNTI­F(A1:A11,">"&1 ) i.e.
drop the "="

Alf