Thread: Sum if statement with a left statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default 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
Reply With QuoteReply With Quote