You may check my attached model according to your description and steps ... It mainly use SUMPRODUCT() and LEFT() function in such a manner to form an appropriate formula
Hope it meets your requirements. OneWhoAlwaysHappyToHelpOthers -eka- On Thu, Oct 16, 2008 at 1:59 AM, ask <[EMAIL PROTECTED]> wrote: > I am looking to sum column E based on a text match in column C. In > column C there are 66 rows that contain text strings. Within the text > string I am looking to match the left four to "abcd" and then sum > those that fall under that condition. The steps are: > > Look at column C > Find those that have "abcd" within the text string > Sum column E based on those that have "abcd" wihtin the text string. > > Thanks, > >
eka - Conditional SUM.xls
Description: MS-Excel spreadsheet
