Filtered SUMIF

I'm trying to use the LEFT function to filter a SUMIF function. What I've tried so far is =sumif(left(A1:A10,3),"ABC",F1:F10), and I get a non-specific error message. Any idea how to go about this?

Try...

=SUMIF(A1:A10,"ABC*",F1:F10)

Hope this helps!

Worked great. I never thought of wildcards. Duh.