How do I do an autosum when data change in columns partly match

[ghrek]

Hi

I know how to do a autosum when there is a change in data in a specific column.

What im trying to do is do an autosum when there is a change in data in a specific column BUT some of the data partly has the same word and need it added.

I.E lets say in column B there is data with BRONDESBURY and BRONDESBURY SST . Under normal circumstances it would do BRONDESBURY and BRONDESBURY SST as separate totals but I need it to add the 2 totals together. I will get the same with numerous locations down the workbook that show SST and non SST.

Is there anyway I can do this?

Thanks..