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

[Jen]

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

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Jen]

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]

You could try this:

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

commit with CTRL-SHIFT-ENTER.

Hope this helps.

Pete

 

[Jen]

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

Jen

 

[Pete_UK]

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

Pete