counting a range that has only general format

  • Thread starter Thread starter E
  • Start date Start date
Hi,

AFAIK that can't be done with countif. How about a UDF.

Alt +F11 to open VB editor. Right click 'ThisWorkbook' and insert module and
paste the code beolw in

call with

=CountGeneral(A!:A10)


Function CountGeneral(rng As Range) As Long
For Each c In rng
If c.NumberFormat = "General" Then
CountGeneral = CountGeneral + 1
End If
Next
End Function
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top