Sum if statement with a left statement
 

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

Sum if statement with a left statement
 

Maybe this:

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

--
Biff
Microsoft Excel MVP


"Eric D" wrote in message
...
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

Sum if statement with a left statement
 

=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

Sum if statement with a left statement
 

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

Sum if statement with a left statement
 

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


"Eric D" wrote:

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