di G6: =SUMPRODUCT(($C$3:$C$59=G$5)*($D$3:$D$59=$F6)) masak lupa sihhhh* sama nama tengahnya bang Zamproduct? :) buat boss2 yang cari jagoan excel jangan lupa contact dia yaahhh...
regards, abimono *gimana kalo pertanyaan yang jawabannya sumproduct diapprove sebulan sekali? :) :) :) On Fri, Sep 12, 2008 at 8:27 AM, Sabil Priatna < [EMAIL PROTECTED]> wrote: > Dear XL master > > boleh bantu ga... data terlampir > thak's banget yang bisa bantu > > > Regards. > Yana Sabil Priatna > Warranty & Claim Engine > PT. Astra Honda Motor > Jl. Inspeksi Tipar Cakung Drain > Jakarta > Telp. (021)46835020 ext. 6249 > email : [EMAIL PROTECTED] > >
Xl-mania.xls
Description: MS-Excel spreadsheet
