I am struggling to find the sum of the count of appearance of substring in a string array. have attached the image with the problem statement and expected output. Tried using the length and substitute function to solve - did not help with sum but.
Screenshot (117).png
(LEN(C2)-LEN(SUBSTITUTE(C2, C4, "")))/LEN(C4)
Any help is appreciated.
Hi and Welcome
Try this. We prefer you to provide your workbook but I did you s favour and recreated it this time
It uses this formula but have a look at the attached.
=SUMPRODUCT(--(ISNUMBER(FIND(G3,$B$3:$B$8))),$C$3:$C$8)
Happy with my advice? Click on the * reputation button below
Formula:
=SUMIF($B$3:$B$8,"*hello*",$C$3:$C$8
Formula:=SUMIF($B$3:$B$8,G3,$C$3:$C$8)
"G3" = *hello*criteria
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks