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

"JulieD" wrote:

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



"csfrolich" wrote in message
...
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