LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
dcd123
 
Posts: n/a
Default countif criteria only one word of few doesn't work


I am trying to use countif where the criteria in some cases will be one
word from a cell that has several words in it. I'm getting a total
count of 0 in these instances. Is there a way to set the criteria to
work this way or perhaps a different counting function?

Thanks!


--
dcd123
------------------------------------------------------------------------
dcd123's Profile: http://www.excelforum.com/member.php...o&userid=25396
View this thread: http://www.excelforum.com/showthread...hreadid=397377

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
How do I create a COUNTIF function with more than one criteria? BCowans Excel Worksheet Functions 2 June 14th 05 08:04 PM
Countif formula with multiple criteria ie >30 and <60? Dali Excel Worksheet Functions 2 January 7th 05 04:49 PM
Countif with dynamic criteria FinChase Excel Worksheet Functions 5 January 6th 05 07:19 PM
use a date range as criteria in a countif formula mbparks Excel Worksheet Functions 3 January 2nd 05 11:06 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"