User Profile
Carpusina
Copper Contributor
Joined Oct 21, 2022
User Widgets
Recent Discussions
Re: I am trying to search and sum values
Hi, thank you for response. Your formula search and sum values but put answer in each row of searched word. I would like to put sum of those words that are found in one cell. For example that I gave, I would like to put it in E1 and that results would need to be 17. I hope I explained good. I tried to add sum before and worked great. Thank you very much.2.2KViews0likes5CommentsI am trying to search and sum values
Hi, I am tying to make a search and sum some datebase. for example: A B C D E fekaufland 5 Namirnice wolt 6 kaufland kaufland 4 lidl konzum 8 konzum I need to seach for all words in column D in column A and when words are found sum there values and put it in E1. I tryed with one word and its working. This is formula I used: =SUM(IF(ISNUMBER(SEARCH("kaufland";A2:A5));B2:B5;"")) But when I try to search for more words its not working. This is formula I am trying: =SUM(IF(ISNUMBER(SEARCH(D2:D5;A2:A5));B2:B5;"")) Can someone help?Solved2.4KViews0likes7Comments
Recent Blog Articles
No content to show