Hi Forum,
Want count the conditional occurrences of specific string in a range. Using the following formula bout giving error.
If someone can find where I am mistaking.
=SUMPRODUCT(--((SEARCH("Test",$A$1:$A$8,1)>0)),--($B$1:$B$8="London"))
<tbody>
</tbody>
Want count the conditional occurrences of specific string in a range. Using the following formula bout giving error.
If someone can find where I am mistaking.
=SUMPRODUCT(--((SEARCH("Test",$A$1:$A$8,1)>0)),--($B$1:$B$8="London"))
Test 01 | London |
Test 02 | LA |
Test 03 | London |
Test 04 | LA |
Fest 01 | London |
Test 03 | LA |
Test 04 | London |
Fest 04 | LA |
#VALUE! | |
<tbody>
</tbody>