Dear Para Master,
Case pertama sudah selesai tetapi ada yang ke dua , Mohon bantu solusi formula tanpa row bantuan, contoh yang di inginkan terlampir... Thanks. Regards, Yudi ---------- Forwarded message ---------- From: Yudi Dwiyono <[email protected]> Date: 2015-11-30 8:18 GMT+07:00 Subject: Fwd: menghasil kan level persen To: [email protected] Dear Mr Kid, Boleh saya tahu fungsi sumproduct dan mengapa di kali 1. Biar tambah ilmu saja nih... Thanks Regards, Yudi ---------- Forwarded message ---------- From: Yudi Dwiyono <[email protected]> Date: 2015-11-28 9:29 GMT+07:00 Subject: Re: menghasil kan level persen To: "[email protected]" <[email protected]> Its working .....thanks a lot mr kid Regards Yudi On Friday, November 27, 2015, 'Mr. Kid' [email protected] [belajar-excel] < [email protected]> wrote: > > > Hai Yudi, > > Coba begini : > =SumProduct( (d9:d11>=b9:b11) * 1 ) / CountA( a9:a11 ) > > Regards > Kid > > > > > 2015-11-27 11:19 GMT+07:00 Yudi Dwiyono [email protected] [belajar-excel] <[email protected]>: >> >> >> >> Dear Masters, >> >> Mohon bantuan untuk formula aga dapa menghasil kan service level yang benar >> >> saya mempunyai contoh seperti terlampir >> sekali lagi mohon bantuannya ya para master. >> Thanks. >> >> Regards, >> Yudi >> > >
Level_1.xlsx
Description: MS-Excel 2007 spreadsheet
