Hi DILIPandey,

I think I was not clear on my original post.

If you change your formula to =SUMIF(Sheet1!$B:$B,"Sheet2!$B5",Sheet1!$W:$W) you get 0 for an answer and this is correct because 22913 <> 0000022913. What you sent in your spreadsheet is what I do NOT want to happen. Once I update to the above formula I get the result I want but I can't copy down the formula.

Thanks,

Mike