Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Sun, 2 Sep 2007 20:40:57 -0400, "Ron Coderre"
wrote: Just use a wildcard to make Excel treat the criteria as text... Try this =COUNTIF(A1:A10,"010020*") Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) Learn something new every day here. --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF not working w/ cells result of SUM and VLOOKUP | Excel Worksheet Functions | |||
CountIf Array not working | Excel Discussion (Misc queries) | |||
Countif, not working. | Excel Discussion (Misc queries) | |||
Countif with nested function not working? | Excel Worksheet Functions | |||
countif not working | Excel Discussion (Misc queries) |