Count a text string if criteria is found

Solved/Closed

love2garv Posts 11 Registration date Wednesday September 16, 2009 Status Member Last seen June 16, 2011 - Sep 17, 2009 at 03:03 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 17, 2009 at 05:46 AM

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...

Count a text string if criteria is found
Vba select case string contains - Guide
How to count names in excel - Guide
Excel count occurrences of string in column - Guide
Do chats count towards best friends on snapchat 2023 - Guide
Unexpected t string php - Guide

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 17, 2009 at 05:46 AM

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"))

Similar discussions

Excel - IF function with multiple words

Counting cells containing only numbers

how to count sentences in a paragraph..." using c language

If cell contains multiple text how to add other cell value?

Code for macro that conditionally inserts rows

Similar discussions

Subscribe To Our Newsletter!