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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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"))
3