i have a array in one cell (A1) , like this:
and i have a table of prices, like this:
data - cost
dog - 1
cat - 2
fish - 3
i want to get a formula that sum all the array, 1+2+3=6.
i traied to put this, its work in Excel, but dont wotk in Coda…