why?

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