Prev: view & update (VBA-command button) two sheets concurrently
Next: Include guid (uuid) from Access in Excel
From: John on 11 Jan 2010 00:38
vba excel 07
Want to count all strings that are two characters long in a range. Using
countif(range, "??") but it doesn't work.

The strings are numbers so I think that might be screwing it up. Tried
countif(range,"<100") but that didn't work either.

John
From: Per Jessen on 11 Jan 2010 03:17
Hi John

Look at theese examples:

Sub CountIt()
'Numbers only
Set MyRange = Range("A1:A100")
MyCount = WorksheetFunction.CountIf(MyRange, "<100") _
- WorksheetFunction.CountIf(MyRange, "<10")
Debug.Print MyCount
End Sub

Sub CountIt2()
'Numbers and text count
Dim MyRange As Range
Set MyRange = Range("A1:A100")

For Each c In MyRange.Cells
If Len(c) = 2 Then MyCount = MyCount + 1
Next
Debug.Print MyCount
End Sub

Hopes this helps.
....
Per


"John" <john6528(a)comcast.net> skrev i meddelelsen
news:OKBjXBokKHA.5820(a)TK2MSFTNGP06.phx.gbl...
> vba excel 07
> Want to count all strings that are two characters long in a range. Using
> countif(range, "??") but it doesn't work.
>
> The strings are numbers so I think that might be screwing it up. Tried
> countif(range,"<100") but that didn't work either.
>
> John

From: michdenis on 11 Jan 2010 06:16
Hi,

Validation using the keys : CTRL + Maj + Enter

=Sum(if(len(Your_Range)=2;1))



"John" <john6528(a)comcast.net> a �crit dans le message de groupe de discussion :
OKBjXBokKHA.5820(a)TK2MSFTNGP06.phx.gbl...
vba excel 07
Want to count all strings that are two characters long in a range. Using
countif(range, "??") but it doesn't work.

The strings are numbers so I think that might be screwing it up. Tried
countif(range,"<100") but that didn't work either.

John

 | 
Pages: 1
Prev: view & update (VBA-command button) two sheets concurrently
Next: Include guid (uuid) from Access in Excel