I'd like to use the Insert - Name - define function to define a group. The group in this case consists of 4 different labels. They are a mixture of text & numbers. For example i've entered these in cells A1-A4

BB-75
76
BB-77
BB-78

Then I want to use this group (Named "BB") and use it in a sumproduct formula so if my data is in columns C & D, and the my data that could match the BB group is in column C, with numerical entries in column D, I get the total of all entries in column D with corresponding entries in column C equal to one of the items in my defined group.

EG Of expected result:

C.............D
BB-75.......10
90............6
BB-78.......15

I would like my sumproduct formula to return 25

Is this possible?

Thanks in advance for the help.