Previous Topic Next Topic

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

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

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
how to count sentences in a paragraph..." using c language
gealon2024 -
indhu -

4 responses
If cell contains multiple text how to add other cell value?
Iza -
TrowaD -

1 response
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses