Hi

I have been using a "SUM" formula to determine the last time a number appeared in the lottery draws,
but i been doing when a number is in single Cell.

But now i trying to SUM Combination of Pick 5 or 6 numbers with "-" (01-02-03-04-05) lottery numbers with in Single Cell, and i can't find help.
(Numbers are aprox 2500 to 3600 in a Single Cell each Pick )

Example : 
         Column G            Column H     
          Pick Numbers           SUM 
G6  =    22-33-34-35-36          160   
G7  =    08-28-29-30-35          130  
G8  =    01-18-23-33-35          110
I need to get the total Sum on Column H

Is there a way to do this with function formula?



Thanks in advance

David.