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

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

"csfrolich" wrote:

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

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

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

"csfrolich" wrote:

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

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

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

"Phil Osman" wrote:

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

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

sorry Phil, of course you are correct

"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

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=ADF(A1:A11,""&1 ) i.e.
drop the "=3D"

Alf

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=ADF(A1:A11,""&1 ) i.e.
drop the "=3D"

Alf