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

[Newbie81]

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

[JE McGimpsey]

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