Problem with SUMIF() and CONCENTRATE()?

[SashaFierce14]

Hello!

I have a Helper column, which I set up using CONCENTRATE. The Helper column basically merges two text columns into one. What I am trying to do is check whether the Helper Column (Sheet 2 column A) contains a specific text, and, if it does, sum the corresponding values in Sheet 2 column F.

I use this formula on Sheet 1, where A2 would, for example, refer to the word "Book" (but A3 would be coffee etc.):

=SUMIF('Sheet2'!$A:$A,"*"&A2&"*",$F:$F)

However, for some reason, my result is always 0.

Any insights into why this may be happening and suggestions for how to solve this error are GREATLY appreciated!

[Glenn Kennedy]

Try:

=SUMIF(Sheet2!$A:$A,"*"&A2&"*",Sheet2!$F:$F)

[SashaFierce14]

Thank you so very much! Glad it was something obvious that I was just missing

[Glenn Kennedy]

Yea, I'm afraid it was... this time!!