Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |