sir, Please find attached sheet, SumProduct formula worked but while dragging it is copying same numbers please check Thanks Nitin