LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default Count no of cells containing data for more than one criteria

Hi

Is there any formula, which can retrieve the count of cells in a range which
contains some specific words.
EG: A column contains rose,jasmine,flower,dress,color etc. From this list of
data i need to get the number of cells contains rose, jasmine and color.
Thanks in advance

Regards
jasmine
 
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
Count Cells that meet Criteria kmason Excel Worksheet Functions 6 August 24th 06 04:31 PM
How do I count data with criteria from two separate columns in exc Scott Excel Worksheet Functions 1 March 2nd 06 04:17 AM
Pull data from another sheet based on certain criteria steve_sr2 Excel Discussion (Misc queries) 1 February 23rd 06 10:08 AM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM
Count cells with data shoiley New Users to Excel 5 November 28th 04 07:23 PM


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

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

About Us

"It's about Microsoft Excel"