Selamat malam, Kenapa pakai rumus ini file excel jadi berat ya master =IFERROR(INDEX(Record!$A$5:$G$50000;MATCH(1;(Record!$D$5:$D$50000='Catatan Cuti Bulanan'!$C9)*(Record!$E$5:$E$50000='Catatan Cuti Bulanan'!E$7);0);6);"")
-
4 bulan yang lalu
-
bagian ini Record!$D$5:$D$50000, datanya memang sebanyak itu? kalkulasi mejadi lebih lama
-
Terimakasih.
Kenapa ya bagian Presence hasilnya REF? padahal rumus nya sama.
Rumus Presence
=SUMPRODUCT((MONTH('Kalkulasi Gaji'!$C$7:$C$577)=MONTH($F$2))*('Kalkulasi Gaji'!$D$7:$D$577=$D$14)*'Kalkulasi Gaji'!$BK$7:$BK$577)Rumus Sick
=SUMPRODUCT((MONTH('Kalkulasi Gaji'!$C$7:$C$577)=MONTH($F$2))*('Kalkulasi Gaji'!$D$7:$D$577=$D$14)*'Kalkulasi Gaji'!$BF$7:$BF$577)Rumus Excused
=SUMPRODUCT((MONTH('Kalkulasi Gaji'!$C$7:$C$577)=MONTH($F$2))*('Kalkulasi Gaji'!$D$7:$D$577=$D$14)*'Kalkulasi Gaji'!$BI$7:$BI$577)Rumus Alpha
=SUMPRODUCT((MONTH('Kalkulasi Gaji'!$C$7:$C$577)=MONTH($F$2))*('Kalkulasi Gaji'!$D$7:$D$577=$D$14)*'Kalkulasi Gaji'!$BJ$7:$BJ$577)
