how to xlookup if the search keys are comma-separated.

Hello,
I have an excel sheet attached. I am trying to xlookup some search keys are comma-separated in excel.
What I would like to do is to SUM up all the returned values into a single cell. I dont know if this is possible for I have to use some VBA scripts.

I tried =XLOOKUP(F2,$A$1:$A$14,$B$1:$B$14)

Any ideas would be greatly appreciated.

a.JPG