| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Try this: > > =SUMPRODUCT(--(LEN(myRange)=2)) > > Hope this helps. > > Pete > > On Jun 26, 12:59 pm, "Jen" <Jen.Carllson_NGM...@gmail.com> 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 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <Jen.Carllson_NGM...@gmail.com> 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" <pashu...@auditel.net> wrote in message > > news:(E-Mail Removed)... > > > > > Try this: > > > =SUMPRODUCT(--(LEN(myRange)=2)) > > > Hope this helps. > > > Pete > > > On Jun 26, 12:59 pm, "Jen" <Jen.Carllson_NGM...@gmail.com> 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 - |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Hi Pete,
Yes it worked! But htat you knew already  Jen "Pete_UK" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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" <Jen.Carllson_NGM...@gmail.com> 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" <pashu...@auditel.net> wrote in message >> >> news:(E-Mail Removed)... >> >> >> >> > Try this: >> >> > =SUMPRODUCT(--(LEN(myRange)=2)) >> >> > Hope this helps. >> >> > Pete >> >> > On Jun 26, 12:59 pm, "Jen" <Jen.Carllson_NGM...@gmail.com> 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 - > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thanks for feeding back, Jen - glad it worked for you.
Pete On Jun 27, 7:45 am, "Jen" <Jen.Carllson_NGM...@gmail.com> wrote: > Hi Pete, > Yes it worked! But htat you knew already > > Jen > > "Pete_UK" <pashu...@auditel.net> wrote in message > > news:(E-Mail Removed)... > > > > > 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" <Jen.Carllson_NGM...@gmail.com> 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" <pashu...@auditel.net> wrote in message > > >>news:(E-Mail Removed)... > > >> > Try this: > > >> > =SUMPRODUCT(--(LEN(myRange)=2)) > > >> > Hope this helps. > > >> > Pete > > >> > On Jun 26, 12:59 pm, "Jen" <Jen.Carllson_NGM...@gmail.com> 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 - |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Count occurences over range if a certain criteria met | Richhall | Microsoft Excel New Users | 6 | 31st Dec 2009 06:41 AM |
| Count occurences of text in range only when Yes appears in other c | eliyahuz | Microsoft Excel Worksheet Functions | 9 | 26th Oct 2009 05:23 PM |
| Count number of occurences within a time range | zebulebu@gmail.com | Microsoft Excel Misc | 5 | 10th Sep 2006 06:48 AM |
| How do I count occurences in a date range? | =?Utf-8?B?SmVyZW15?= | Microsoft Excel Worksheet Functions | 2 | 8th Jul 2005 11:21 PM |
| How do I count the number of alpha occurences in a range? | =?Utf-8?B?Q1JN?= | Microsoft Excel Worksheet Functions | 2 | 30th May 2005 04:08 PM |
