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

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

"JEH" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
> >
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
> >
>
>
>