Posted to microsoft.public.excel.programming

John[_132_] John[_132_] is offline

external usenet poster

Posts: 30

countif not working

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif Range not working	tommcbrny	Excel Worksheet Functions	4	August 1st 08 05:29 PM
Countif not working	c mateland	Excel Worksheet Functions	3	September 3rd 07 02:46 AM
CountIf Array not working	NWO	Excel Discussion (Misc queries)	1	March 1st 07 07:48 PM
Countif, not working.	Clash	Excel Discussion (Misc queries)	2	July 20th 06 11:28 AM
countif not working	Nick Krill	Excel Discussion (Misc queries)	4	June 24th 06 07:42 PM

All times are GMT +1. The time now is 06:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us