SUMIF problem
 

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?

In article ,
"Nadia" wrote:

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.

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nadia" wrote in message
...
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!

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
-----Original Message-----
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?

In article ,
"Nadia" wrote:

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.
.