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
>
>
> 
>
  • [belajar-excel] mengh... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
    • Re: [belajar-exc... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
      • [belajar-exc... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
        • [belajar... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
          • [bel... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
          • Re: ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
            • ... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
              • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
                • ... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
                • ... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]
                • ... Jan Raisin miss.jan.rai...@gmail.com [belajar-excel]
                • ... Yudi Dwiyono yudidwiy...@gmail.com [belajar-excel]

Kirim email ke