In the example below I need to write a formula that can add any cells that
contain the "&".

Column A Column B
Fred & Mary 1540.00
Fred & Mary 135.00
Fred & Mary 110.00
Bill 1170.00
Bill 110.00
Mary 1475.00
Mary 100.00

Because the names 'Fred & Mary' differ between spreadsheets, the "&" is the
only common denominator. For example I need to know what the 'contains' word
should be in the formula: =Sumif(a1:b7,contains"&",b1:b7).

Any ideas gratefully received.
Thanks