Dear Sir,

Thank you, but above formula is very near to return value, but not as per requirement so i've added column name Month in "mmm-yy" format added below formula and its working like a charmAttachment 868656

SUMPRODUCT(Target!$F$2:$F$3925,IF(TEXT(Target!$E$2:$E$3925,"mmm-yy")=Data!$H10604,1,0)*(Target!$C$2:$C$3925=Data!$K10604)*(Target!$A$2:$A$3925=Data!$J10604))