Terima kasih semuanya atas penjelasan2 nya. sekarang running well filenya
Salam: |Rasyid| ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jkssxls Sudarsono Sent: Thursday, January 26, 2012 5:28 PM To: Belajar-Excel Yahoo Groups Subject: RE: Bls: [belajar-excel] Fungsi Sumproduct tidak mengkalkulasi misal J33 sampai J34 berisi nilai yang jika menggunakan Value() akan menghasilkan #Value! , misal value(J33) dan value (j34 ). hal aneh : 1. =SUMPRODUCT(F33:F33,J33:J33) akan menghasilkan #Value! 2. =SUMPRODUCT(F33:F34,J33:J34) akan menghasilkan 0 jadi jika rangenya lebih dari satu sel akan menghasilkan 0 ________________________________ To: [email protected] From: [email protected] Date: Thu, 26 Jan 2012 09:16:26 +0000 Subject: RE: Bls: [belajar-excel] Fungsi Sumproduct tidak mengkalkulasi karena sel J33:j1001 ada isinya dan bukan merupakan number sehingga : =VALUE(J33) akan menghasilkan #Value! bila isi sel j33 dihapus , alias dikosongkan : =VALUE(J33) akan menghasilkan 0 =SUMPRODUCT(($D$2:$D$1001="January")*($F$2:$F$1001="SHE") * $J$2:$J$1001) akan menghasilkan #Value! bilai menggunakan : =SUMPRODUCT(($D$2:$D$1001="January")*($F$2:$F$1001="SHE"),$J$2:$J$1001) maka nilai perkalian antar sel yang bersesuaian akan menghasilkan 0 , walaupun sel di kolom J bukan bertipe number atau bukan tipe yang dapat di konversikan ke number. misal =SUMPRODUCT((D33:D3="January")*(F33="SHE"),J33) perkalian/product nilai 0 (dari False * False ) dan #Value! akan menghasilkan 0. ________________________________ To: [email protected] From: [email protected] Date: Thu, 26 Jan 2012 15:25:16 +0800 Subject: Bls: [belajar-excel] Fungsi Sumproduct tidak mengkalkulasi boleh saya ralat SUMPRODUCTnya =SUMPRODUCT(($D$2:$D$1001="January")*($F$2:$F$1001="SHE"),$J$2:$J$1001) ________________________________ Dari: "Contract Mining Assistant, Asam-Asam" <[email protected]> Kepada: [email protected] Dikirim: Kamis, 26 Januari 2012 14:08 Judul: [belajar-excel] Fungsi Sumproduct tidak mengkalkulasi #VALUE! --> range data sampai baris 1001 224.00 --> range data hanya sampai cell input terakhir baris 32 Dear Para Pakar Excel saya mempunyai masalah dengan sumproduct, sumproduct yang saya tulis selalu error kalau range data melebihi dari cell terakhir yang telah ter input Mohon Solusi terbaiknya. Terima Kasih Salam: |Rasyid| Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments. Disclaimer - This message including any attachments and information contained herein ("Message" ) may contain privileged information or otherwise is protected from disclosure. Any unauthorized use of this Message by any person may lead to legal consequences. If you receive this Message in error, or if the recipient of this Message is not the intended recipient or the employee or agent authorized for delivering this Message to the intended recipient you are hereby notified that any disclosure, dissemination, distribution or copying of this Message or let or cause this Message to be disclosed,disseminated, distributed, or copied is strictly prohibited, and please notify the sender by return message and immediately delete this Message from your system. Incoming and outgoing communications using this electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable law and regulations. Unless it is made by the authorized person,any views expressed in this Message are those of the individual sender and may not necessarily reflect the views of PT Arutmin Indonesia. You should check attachments for viruses and defects before opening or using them. We are not liable to recover any injuries caused by virused or defected attachments.
