Sum if statement with a left statement

[Eric D]

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

Can anyone help me on the formula?

Thanks

 

[T. Valko]

Maybe this:

=SUMIF(C2:C10,"818590*",H2:H10)

 

[John C]

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

 

[Eric D]

thank you both of these work wonderfully

 

[John C]

Thank you for the feedback, don't forget to check the Yes box.