Count a text string if criteria is found
Solved/Closed
love2garv
Posts
11
Registration date
Wednesday 16 September 2009
Status
Member
Last seen
16 June 2011
-
17 Sep 2009 à 03:03
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 Sep 2009 à 05:46
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 Sep 2009 à 05:46
Related:
- Count a text string if criteria is found
- Excel count occurrences of string - Guide
- How to hide subscriber count - Guide
- Count names in excel - Guide
- Vba select case string - Guide
- Excel count cells with numbers - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
17 Sep 2009 à 05:46
17 Sep 2009 à 05:46
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"))
use this formula
=SUMPRODUCT((A1:A8="jamshedpur")*(B1:B8="copy"))
