I'm trying to return the SUM of a set of numbers, which are comma seperated in another cell.

I'm listing out the unique values in column 1, and trying to SUM the numbers in column 2.

Client A 0,56.3,0,450,90,22.6,22.6,0,180,0,90,67.6,67.6,67.6,90,225,450

The expected outcome is 1879.3 for Client A.

But how can I do this for every new client and set of numbers added? I have tried a combination of SUM and SPLIT, but I can't get it work for every value in column A in an arrayformula.

Here is the file: