ExcelBanter - Counting occurance of letters or numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting occurance of letters or numbers (https://www.excelbanter.com/excel-discussion-misc-queries/19012-counting-occurance-letters-numbers.html)

csfrolich

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

Phil Osman

=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

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

"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

Kassie

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

Phil Osman

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

Phil Osman

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

JulieD

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

JulieD

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

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

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

Alf

All times are GMT +1. The time now is 07:22 AM.