thank you both of these work wonderfully
--
Eric


"John C" wrote:

=SUMPRODUCT(--(LEFT(C2:C100,6)="818590"),(H2:H100))
--
John C


"Eric D" wrote:

I am trying to sum column H when column C's first 6 characters are "818590".

Can anyone help me on the formula?

Thanks
--
Eric