hi sir, please help me i want to use the formula " sumproductif " ,as " sum if ".. can it is possible.. please use the undergiven link for my problem. rapidshare.com/files/302276522/querry.xls.html waiting for solution.. as on my personal mail id joshirohit123@rediffmail.com thakns