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:
belajar-excel@yahoogroups.com
From: saif...@ymail.com
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" <apassist...@arutmin.com>
Kepada: belajar-excel@yahoogroups.com
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.
