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

N

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
 
J

JE McGimpsey

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?
Click to expand...

One way: =SUMIF(A:A,"*Cabin*",B:B)
I am just starting to learn VBA is this something VBA could easily do?
Click to expand...

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?
Click to expand...

This sounds like a perfect application for a Pivot Table:

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