Counting occurance of letters or numbers

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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