Hello,
I have a column with values which are semi colon separated 1233; 2354; 4576 in another tab I have score values for each. I want to bring for each row sum of the score values.
Excel attached.
Thanks
Hello,
I have a column with values which are semi colon separated 1233; 2354; 4576 in another tab I have score values for each. I want to bring for each row sum of the score values.
Excel attached.
Thanks
Try in Cell C2
=SUMPRODUCT(COUNTIF(B2,"*"&Sheet2!$A$2:$A$5&"*"),Sheet2!$B$2:$B$5)
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Works brilliantly!
And If I want to return the score value for each in separate columns? So I have column C with total followed by column showing value from the first ID and column showing value from the second ID ?
I thought there might be more than two values in Col B. If there are only two at all times use these for individual values
=INDEX(Sheet2!$B$2:$B$5,MATCH(TRIM(LEFT(SUBSTITUTE($B2,";",REPT(" ",255)),255))*1,Sheet2!$A$2:$A$5,0))
and
=INDEX(Sheet2!$B$2:$B$5,MATCH(TRIM(RIGHT(SUBSTITUTE($B2,";",REPT(" ",255)),255))*1,Sheet2!$A$2:$A$5,0))
I have many indeed but for some I need to count sum and for some lines just the score of the first.
It works.
Thank you soooo much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks