try formula : =SUMPRODUCT((LEFT(C1:C66,4)="abcd")*E1:E66) is this what you mean ?
-- Belajar mendapat penghasilan dari Internet dengan benar & profesional. Kursus online Internet Marketing hanya 199rb/bulan. Klik di sini<http://wwwhkuhlknm.m,;il> 2008/10/16 ask <[EMAIL PROTECTED]> > 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, > > >
