Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting a range that has only general format
I'm attempting to count cells in a range that have a general format. Need
help with countif. -- 1 putt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting a range that has only general format
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. "E" wrote: I'm attempting to count cells in a range that have a general format. Need help with countif. -- 1 putt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is defaulting to Number format instead of General format | Excel Discussion (Misc queries) | |||
Change General format to Date format | Excel Discussion (Misc queries) | |||
General Format to Custom format problem | Excel Discussion (Misc queries) | |||
Format: General - Text - General | Excel Worksheet Functions | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions |