Thread: SUMIF problem
View Single Post
  #1   Report Post  
Nadia
 
Posts: n/a
Default 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!