How to count the occurences in my range with 2 characters only?
 

Hello There,

I am wondering how you can count the number of occurences in myRange that
contains 2 charters only?

This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))
Brgds Jen

How to count the occurences in my range with 2 characters only?
 

Try this:

=SUMPRODUCT(--(LEN(myRange)=2))

Hope this helps.

Pete

On Jun 26, 12:59 pm, "Jen" wrote:
Hello There,

I am wondering how you can count the number of occurences in myRange that
contains 2 charters only?

This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))
Brgds Jen

How to count the occurences in my range with 2 characters only?
 

Hi Pete,

Thanks! WHat it needs to do...! :)


How would an array-formula look like to do the same? I tried
Ctrl+Shift+Enter on =COUNTA(LEN(myRange)=2)
but that's not it.
Jen

"Pete_UK" wrote in message
oups.com...
Try this:

=SUMPRODUCT(--(LEN(myRange)=2))

Hope this helps.

Pete

On Jun 26, 12:59 pm, "Jen" wrote:
Hello There,

I am wondering how you can count the number of occurences in myRange that
contains 2 charters only?

This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))
Brgds Jen

How to count the occurences in my range with 2 characters only?
 

You could try this:

=SUM(IF(LEN(myRange)=2,1))

commit with CTRL-SHIFT-ENTER.

Hope this helps.

Pete

On Jun 26, 3:37 pm, "Jen" wrote:
Hi Pete,

Thanks! WHat it needs to do...! :)

How would an array-formula look like to do the same? I tried
Ctrl+Shift+Enter on =COUNTA(LEN(myRange)=2)
but that's not it.
Jen

"Pete_UK" wrote in message

oups.com...



Try this:

=SUMPRODUCT(--(LEN(myRange)=2))

Hope this helps.

Pete

On Jun 26, 12:59 pm, "Jen" wrote:
Hello There,

I am wondering how you can count the number of occurences in myRange that
contains 2 charters only?

This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))
Brgds Jen- Hide quoted text -

- Show quoted text -

How to count the occurences in my range with 2 characters only?
 

Hi Pete,
Yes it worked! But htat you knew already ;)

Jen

"Pete_UK" wrote in message
ps.com...
You could try this:

=SUM(IF(LEN(myRange)=2,1))

commit with CTRL-SHIFT-ENTER.

Hope this helps.

Pete

On Jun 26, 3:37 pm, "Jen" wrote:
Hi Pete,

Thanks! WHat it needs to do...! :)

How would an array-formula look like to do the same? I tried
Ctrl+Shift+Enter on =COUNTA(LEN(myRange)=2)
but that's not it.
Jen

"Pete_UK" wrote in message

oups.com...



Try this:

=SUMPRODUCT(--(LEN(myRange)=2))

Hope this helps.

Pete

On Jun 26, 12:59 pm, "Jen" wrote:
Hello There,

I am wondering how you can count the number of occurences in myRange
that
contains 2 charters only?

This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))
Brgds Jen- Hide quoted text -

- Show quoted text -

How to count the occurences in my range with 2 characters only?
 

Thanks for feeding back, Jen - glad it worked for you.

Pete


On Jun 27, 7:45 am, "Jen" wrote:
Hi Pete,
Yes it worked! But htat you knew already ;)

Jen

"Pete_UK" wrote in message

ps.com...



You could try this:

=SUM(IF(LEN(myRange)=2,1))

commit with CTRL-SHIFT-ENTER.

Hope this helps.

Pete

On Jun 26, 3:37 pm, "Jen" wrote:
Hi Pete,

Thanks! WHat it needs to do...! :)

How would an array-formula look like to do the same? I tried
Ctrl+Shift+Enter on =COUNTA(LEN(myRange)=2)
but that's not it.
Jen

"Pete_UK" wrote in message

groups.com...

Try this:

=SUMPRODUCT(--(LEN(myRange)=2))

Hope this helps.

Pete

On Jun 26, 12:59 pm, "Jen" wrote:
Hello There,

I am wondering how you can count the number of occurences in myRange
that
contains 2 charters only?

This function does obviously not do the trick:
=SUMPRODUCT(--(ISNUMBER(SEARCH("??",myRange))))
Brgds Jen- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -