counting a range that has only general format

  • Thread starter Thread starter E
  • Start date Start date
E

E

I'm attempting to count cells in a range that have a general format. Need
help with countif.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Countif cell has diagonal border 6
=Countif(range, criteria) 2
countif 3
Using a sub string in a COUNTIF 2
counting cells that fall within a certain date range 9
Count cells that contain data 2
Count function 8

Back
Top