SUMIF problem

  • Thread starter Thread starter Nadia
  • Start date Start date
N

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!
 
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?
 
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
 
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
 
Back
Top