Hai Tjahya, Formula di dalam file terlampir ada yang menggunakan SumIFs dan ada yang menggunakan CountIFs.
Regard, Kid 2015-06-10 23:48 GMT+10:00 Tjahya Hartono [email protected] [belajar-excel] <[email protected]>: > > > Dear Be Excel, > > Gimana ya merumuskan rumus yang panjang jadi pendek, seperti dibawah ini: > =COUNTIFS('input absen '!$C$9:$C$2500,B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$4)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$5)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!D9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$6)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$7)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$8)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$9)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$10)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$11)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$12)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$14)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$15)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$16)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$17)+COUNTIFS('input absen '!$C$9:$C$2500,'Daftar > gaji'!B7,'input absen '!$D$9:$D$2500,">="&$C$3,'input absen > '!$D$9:$D$2500,"<="&$D$3,'input absen '!$E$9:$E$2500,$H$18)+COUNTIFS('input > absen '!$C$9:$C$2500,'Daftar gaji'!B7,'input absen > '!$D$9:$D$2500,">="&$C$3,'input absen '!$D$9:$D$2500,"<="&$D$3,'input absen > '!$E$9:$E$2500,$H$13) > Saya bingung, gmana mempersingkatnya, > Untuk lebih jelasnya saya berikan dalam lampiran dibawah. > > > > > Salam Hangat > > > > Tjahya > > > >
re-Rumus Panjang Jadi Pendek.xlsx
Description: MS-Excel 2007 spreadsheet
