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"))
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!
=SUMPRODUCT(--ISNUMBER(SEARCH("Test",$A$1:$A$8))*--($B$1:$B$8="London"))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thank you all . Its awesome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks