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.
|5||P_GT_ 1000087 Updating||1||1000087|