Bisa juga dengan menggunakan formula SUMIF
Thanks
----- Original Message -----
From: nm kid
To: belajar-excel@yahoogroups.com
Sent: Saturday, May 16, 2009 7:58 AM
Subject: Re: [belajar-excel] #N/A
Dear Faisal,
=IF(IsError(VLookUp(......)),0,VLookUp(....)) +
IF(IsError(VLookUp(...)),0,VLookUp(....))
Kid.
2009/5/16 Faisal Hasman <revolter_ic...@yahoo.com>
[Attachment(s) from Faisal Hasman included below]
dear all excel mania
mohon bantuannya :
saya punya data excel yang saya olah pakai vlookup
ada 2 sheet yaitu sheet bonus crt dan sheet bonus pcs
rencananya saya mau gabung (menjumlahkan) keduanya pada sheet bonus
gabungan
permasalahannya :
tidak semua kode barang di "pcs" ada di sheet "crt" sehingga hasil jumlahnya
menjadi #N/A
pertanyaannya :
bagaimana cara menggabungkan keduanya.. dan jika salah satu kode tidak
berada pada
sheet lain maka hanya membaca satu sheet yang ada nilainya..
atau
#N/A berubah menjadi 0.
contoh saya lampirkan
terima kasih atas bantuannya
----------------------------------------------------------------------------
.
DISCLAIMER
---------------
"This email and any files transmitted with it are private and confidential
and intended solely for the use of the individual or entity to which they are
addressed. If you have received this email in error please notify the system
manager. If you are not an intended recipient, you are hereby notified that any
disclosure, copying, or distribution of this email, and/or taking any action
based on its content, is strictly prohibited, and you should: (i) immediately
delete this email and its attachments from your system, and (ii) inform the
sender by reply email that you are not an intended recipient. Please note that
any views or opinions presented in this email are solely those of the
author/sender and do not necessarily represent those of ANJ Agri Group. ANJ
Agri Group does not accept (i) any liability for its employee's communications
that are against ANJ Agri's core values and/or outside the scope of employment
and (ii) any damage caused by any virus transmitted by this email. Details can
be found at: http://www.anjagri.com/disclaimer.htm";
DISCLAIMER<br />
---------------<br />
"This email and any files transmitted with it are private and
confidential and intended solely for the use of the individual or entity
to which they are addressed. If you have received this email in error
please notify the system manager. If you are not an intended recipient,
you are hereby notified that any disclosure, copying, or distribution of
this email, and/or taking any action based on its content, is strictly
prohibited, and you should: (i) immediately delete this email and its
attachments from your system, and (ii) inform the sender by reply email
that you are not an intended recipient. Please note that any views or
opinions presented in this email are solely those of the author/sender
and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group
does not accept (i) any liability for its employee's communications
that are against ANJ Agri's core values and/or outside the scope of
employment and (ii) any damage caused by any virus transmitted by this
email. Details can be found at: http://www.anjagri.com/disclaimer.htm";
