Getting Excel whilst using the sumif formula to search for part of a word
 

I am using a Sumif formula on a summary page that summarises from a list in
another sheet. This is case and word sensitive, is there any way to get excel
to search for part of a word e.g instead of searching for Cabin Installers
Ltd it could find Cabin?

I am just starting to learn VBA is this something VBA could easily do?

This same workbook i basically a monthly cost spread sheet that comes in and
i have to analysis to show the movement in the month. Is there anyway excel
could auto summarise the sheet e.g For every individual name/company on the
sheet it could find the sum of their costs?

Any help would be most appreciated

Kind Regards

Grant

Getting Excel whilst using the sumif formula to search for part of a word
 

In article <591e37cdfad2d@uwe, "Newbie81" <u16827@uwe wrote:

I am using a Sumif formula on a summary page that summarises from a list in
another sheet. This is case and word sensitive, is there any way to get excel
to search for part of a word e.g instead of searching for Cabin Installers
Ltd it could find Cabin?

One way: =SUMIF(A:A,"*Cabin*",B:B)

I am just starting to learn VBA is this something VBA could easily do?

Yes, but I'm not sure it's needed

This same workbook i basically a monthly cost spread sheet that comes in and
i have to analysis to show the movement in the month. Is there anyway excel
could auto summarise the sheet e.g For every individual name/company on the
sheet it could find the sum of their costs?

This sounds like a perfect application for a Pivot Table:

http://peltiertech.com/Excel/Pivots/pivotstart.htm