SUMIF problem

[Nadia]

I have a column that contains the following text cells:
abc - 123
abc - 455
abc - 333
zzzzsyt
wwtrtzz

I just want to sum up the values corresponding to any cell
that has an "abc - " in it. How do I do this? I've tried:
=SUMIF(range,"*abc*",range) but it doesn't work. Please
help!

 

[JE McGimpsey]

This works for me:

=SUMIF(A:A,"*abc*",B:B)

where the values to be summed are in a separate column. Are you trying
to extract the values from the text cells?

 

[Bernard Liengme]

Would be easier if you had two columns.
This works if the last three characters are the number in each cell
=SUMPRODUCT(--(LEFT(F1:F5,5)="abc -"),VALUE(RIGHT(F1:F5,3)))
best wishes

 

[Guest]

Aha! The problem was that the data range I was specifying
didn't reference the correct column. I've got it! Thanks
for you help
Nadia