View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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