I've a problem with google sheet i have a couple of article with an id, a price and then a list of article buyed. I represented the list of articles buyed by numbers separated with commas.
I know how to find the price of an article by it's id i put it in the sheet. Now i need to know how i can get the total of the articles buyed but i don't find the solution.
Can you help me please ?
In E2 try
=ArrayFormula(mmult(iferror(vlookup(split(D2:D8; ","); A2:B8; 2; 0); 0); {1;1;1}))
Is this what you try to achieve?