I need to do a sumif on data that [contains] a specific string.
 

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

=SUMIF(A1:A7,"*&*",B1:B7)

"JEH" wrote in message
...
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

So simple - I have searched high & low for 'wildcards' but couldn't find
anything. Thanks a lot.

"N Harkawat" wrote:

=SUMIF(A1:A7,"*&*",B1:B7)

"JEH" wrote in message
...
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