Your version makes it so that it gives me the totals for all the numbers in the cell in a list form. I want it so that it give me the total based on the number in a specific cell like xor's function version. (Get input (1001) get total from (1001;60 and 1001;10 and 1800;60) and say the total for 1001 (70)).
Can you edit xor's for me to just ignore anything that doesn't have a semicolon? Again thanks for all your help with this.
|