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
|