[SOLVED] SUMIF Formula Help

[dahh]

I was wondering if anyone could help me improve this formula. I'm currently using the following SUMIF formula to add inventory for certain skus:
=SUMIF('RAW INVENTORY DATA'!A:A,"RR12*",'RAW INVENTORY DATA'!B:B)

However, I am manually changing the sku of the formula ("AAMM12*"). The list of skus are getting larger so I attempted to use cell reference:
=SUMIF('RAW INVENTORY DATA'!A:A,"B2*",'RAW INVENTORY DATA'!B:B)

However, this does not seem to work. Could someone help me figure out the reason why that may be the case?
I have attached a sample document.

Also, on the sample document, there is a section titled picture. I've read through the forums and saw solutions for a picture lookup (http://www.mcgimpsey.com/excel/lookuppics.html).
However, is there an alternative other than a drop-down box?
I was hoping to look up the sku in cell b2 to return a picture. Would it be correct to assume that this would not be possible without macros?

Thank you all in advance.

[Jonmo1]

Try
=SUMIF('RAW INVENTORY DATA'!A:A,B2&"*",'RAW INVENTORY DATA'!B:B)

[dahh]

Thank you so much, it worked perfectly!
May I ask why "B2*" does not work, but B2&"*"?
I would really appreciate the knowledge.

[Jonmo1]

Because it will read "B2*" as literally a text string, not the Contents of the cell B2 and an *

But it will read B2&"*" as the contents of the cell B2 and an *

[dahh]

Ah, I see! Makes sense. Thank you for the explanation.
Learning something new everyday!