Count a text string if criteria is found

Solved/Closed
Report
Posts
11
Registration date
Wednesday September 16, 2009
Status
Member
Last seen
June 16, 2011
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month