Its working .....thanks a lot mr kid Regards Yudi On Friday, November 27, 2015, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] < belajar-excel@yahoogroups.com> 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 yudidwiy...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>: >> >> >> >> 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 >> > >