I10=IF(ISNA(VLOOKUP($D10,'1-28
FEB'!$A$7:$G$143,7,FALSE)),0,VLOOKUP($D10,'1-28 FEB'!$A$7:$G$143,7,FALSE))

Atau

=IF(ISNA(MATCH($D10,'1-28 FEB'!$A$7:$A$143,0)),0,VLOOKUP($D10,'1-28
FEB'!$A$7:$G$143,7,FALSE))

Atau

=SUMPRODUCT(('1-28 FEB'!$A$7:$A$143=rekap!$D10)*'1-28 FEB'!$G$7:$G$143)



Kirim email ke