Search : in
By :

Count a text string if criteria is found

Last answer on Sep 17, 2009 10:46:29 am BST love2garv, on Sep 17, 2009 8:03:08 am BST 
 Report this message to moderators

Hello,
I have a problem and is that I want to count a text string from a range of cells, if the criteria is found correct, for example,

jamshedpur book
ranchi book
dhanbad book
dhanbad copy
dhanbad copy
ranchi copy
jamshedpur copy
jamshedpur copy

Now i want to count & display the number of copy is available for jamshedpur with using any function.

Plz help.
Thanks in Advance...

Configuration: Windows XP Internet Explorer 6.0

Best answers for « count a text string if criteria is found » in :
Text String count within a Cell (Solved) Show
Excel Text String Search/Return Show
Text String count within a Cell Show Text String count within a Cell Issue Solution Note Issue I have number of records (see below) and want to know if I can use a function to count the number of records that contain a specific text string within each cell entry? e.g....
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[C language]Checking whether an integer is a prime number Show[C language]Checking whether an integer is a prime number Definition of a prime number Algorithm 1: dividers between 2 and N-1 will be tested Algorithm 2: Even dividers will not be tested, research is limited to odd dividers Algorithm 3:...
Reducing a Jpg image size ShowReducing a Jpg image size Step 1 (optional!): Skip GREYCstoration on the image Step 2: Reduce the resolution Step 3: Lower quality Step 4: Remove unnecessary information Conclusion If you find that your JPEG files are too large...
Download Jarte ShowIf you find that Microsoft Word is too heavy or too bulky for your machine, use "Jarte". Jarte is a text editor based on the motor of Microsoft WordPad of Windows. It starts in the quarter of tower, furthermore he requires no installation, you can...
Download ShaPlus Bandwidth Meter ShowIf you find that your Internet bill does not correspond to your real consumption, use an adding machine of band passer-by. ShaPlus Bandwidth Meter shows you in the bar of notification your rough consumption of band passer-by. Consumption can be...
Download AM-Deadlink ShowAM-DeadLink detects dead links and duplicates in browser bookmarks and text files. If a bookmark has become unavailable you can verify and delete it permanently. Additionally you can download FavIcons for all your Favorites and Bookmarks. AM...
Ask your question Reply

1

 venkat1926, on Sep 17, 2009 10:46:29 am BST
  • +2

I presume that the city names ae in column A from A1 down and the ifnormation"copy" or otehr wise is in column B from B1 diwb

use this formula

=SUMPRODUCT((A1:A8="jamshedpur")*(B1:B8="copy"))

   
Reply to venkat1926
Ask your question Reply
They need your help