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

J

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
 
J

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
 
P

Pete_UK

You could try this:

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

commit with CTRL-SHIFT-ENTER.

Hope this helps.

Pete
 
Top