Dear all, esp bu siti, Kenalkan nama sy atan, penghuni pasif buat bljr excel.. Mau nanya, kalo dengan attachment yg lalu, trus mau ditanyakan..berapa jumlah item yg bernilai 4(yg pasti ada 2), rumusnya jadi gimana yah..? Oh yah, kalo buku yg bagus dan mdh dipahami buat belajar excel, yg buat intermediate to advanced, recommendednya punya siapa yah? Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT
-----Original Message----- From: siti <[email protected]> Date: Sun, 14 Jun 2009 15:46:56 To: <[email protected]> Subject: Re: [belajar-excel] [Belajar Excel] Count kosong melengkapi saja:... array formula: *=SUM(IF((A1:H1="a")*(A2:H2="");1;0))* lihat workbook lampiran *note: jika data di baris 1 diperbaiki (semula " a " di perbaiki menjadi "a" rumus pak Hamid menghasilkan 6. apa hanya di excel ku saja ya ??* On Wed, Jun 10, 2009 at 2:39 PM, Abdul Hamid <[email protected]> wrote: > Pak Sepriansyah, > Bisa menggunakan formula =SUMPRODUCT(COUNTIF(A1:H1,"A")*(A2:H2=0)), file terlampir > Thanks > > ----- Original Message ----- > From: sepriansyah encep > To: [email protected] > Sent: Wednesday, June 10, 2009 1:49 PM > Subject: [belajar-excel] [Belajar Excel] Count kosong > > Dear Friend > Mohon dibantu ya... > *> a b c d a b a d > 12 5 2 4 4 23 *> > Saya ingin mengetahui berap jumlah a yang kosong, > bagaimana ya...? > > Terimakasih
