Re: [belajar-excel] Isi tabel [1 Attachment] --> format cell 0;0;;@

is > > > - Original Message - > *From:* siti Vi > *To:* belajar-excel@yahoogroups.com > *Sent:* Wednesday, May 20, 2009 10:14 AM > *Subject:* Re: [belajar-excel] Isi tabel [1 Attachment] > > maaf kalalu sudah ada yg menanggapi sebelumnya > > ya SUMPRODUCT l

Re: [belajar-excel] Isi tabel [1 Attachment] --> format cell 0;0;;@

ell -->0;0;;@ saya praktekan di file lain hasilnya angka 1, bukan 0.5. salam Haris - Original Message - From: siti Vi To: belajar-excel@yahoogroups.com Sent: Wednesday, May 20, 2009 10:14 AM Subject: Re: [belajar-excel] Isi tabel [1 Attachment] [Attachment(s) from s

Re: [belajar-excel] Isi tabel [1 Attachment]

maaf kalalu sudah ada yg menanggapi sebelumnya ya SUMPRODUCT lah yauw... ditulis di C3 =SUMPRODUCT(($B$14:$B$23=$A3)*($C$14:$C$23=C$1)) lalu tularkan ke cells di kanan dan bawahnya... 2009/5/20 Pasci, Ade Aries > [Attachment(s) <#1215bdba7f2478ea_TopText> from Pasci, Ade Aries included >

Re: [belajar-excel] Isi tabel [1 Attachment]

Dear Ade, Semoga file terlampir bermanfaat. Thanks and regards. Kid. 2009/5/20 Pasci, Ade Aries > [Attachment(s) <#1215bdbb278e7eb2_TopText> from Pasci, Ade Aries > included below] > > Dear Pakar XL, > > Mohon bantuannya formula untuk mengisi tabel > contoh file terlampir.. > > Rgrds, > Ad

[belajar-excel] Isi tabel [1 Attachment]

Dear Pakar XL, Mohon bantuannya formula untuk mengisi tabel contoh file terlampir.. Rgrds, Ade