LinkBack URL
About LinkBacks
Hello Vegas,
Use SUMIF & COUNTIF with wildcard,
E2, copy down
=SUMIF(A:A,"*"&D2,B:B)
F2, copy down,
=COUNTIF(A:A,"*"&D2)
If kwd may appear anywhere in the cells, use one more "*" after the cell. like,
=SUMIF(A:A,"*"&D2&"*",B:B)
Hello Vegas,
Use SUMIF & COUNTIF with wildcard,
E2, copy down
=SUMIF(A:A,"*"&D2,B:B)
F2, copy down,
=COUNTIF(A:A,"*"&D2)
If kwd may appear anywhere in the cells, use one more "*" after the cell. like,
=SUMIF(A:A,"*"&D2&"*",B:B)
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks