Problem with sumif with wildcard

[patrickmcclean]

Hi, I have two long columns of data. in the first column A I have description that contain a number in this format '1000xx), as you will see this reference number will be entered several times in this column. I have this formula working =sumif(A1:A5,"*1000087*",B1:B5). Is it possible to replace the text/number 100087 with a cell reference that contains that value for example =sumif(A1:A5,"*D2*",B1:B5). Where D2 is the Cell. This will allow me to drag down the formula. Any suggestions would be greatly appreciated.

	A	B	C	D	E	F
1	P_EB_SWS_11 s <tbody> </tbody><colgroup><col></colgroup>	0		1000086
2	P_GT_1000054 Updating	1		1000087		3
3	P_GT_1000087 3G	2		1000088
4	P_GT_1000091 T	1		1000089
5	P_GT_ 1000087 Updating	1		1000087

<tbody>
</tbody>

 

[shyy]

try this =SUMIF(A1:A5,"*"&D2&"*",B1:B5)

 

[patrickmcclean]

try this =SUMIF(A1:A5,"*"&D2&"*",B1:B5)

That worked perfectly thanks