how do I apply existing formula to multiple data separated by comma in same cell?

[ajrilo]

Hello,
I have a spreadsheet that is tracking teams and hours, works perfectly for what I need it to do, however, I did not take into account that more then one team could volunteer on the same day.
how can I modify the formula being used in this spreadsheet to still do the same thing it is doing now but for an entry like the example in cell P16?

formula in cell A35 is =SUMPRODUCT(--(LEFT("0"&D$3:D$33,2)+0=$A$35),("0"&MID(D$3:D$33,3,9))+0)

But I do not know how to apply it to multiple entries separated by a comma (like example in cell P16 and whit if all 4 teams worked the same day?)

any help would be greatly appreciated

 

[ajrilo]

Cell A35 is the cell with 2.5 in it at the bottom of the table, cell P16 is the cell with 4-2,3-1 in the same cell