Hai Guswi,Coba pakai Data Consolidate, dengan mengaacu kepada 3 kolom terakhir dari Data pada tiap2 Sheet.Posisi sel pada saat melakukan Data Consolidate harus berada pada "Part Number" di Sheet Data_Consolidate.Selamat mencoba. Jika ada perubahan data maka proses Data Consolidate harus diulangi (tidak otomatis). File terlampir. Salam,HK
From: "'Agus Widodo' [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Tuesday, 7 June 2016, 12:06
Subject: [belajar-excel] penjumlahan gabungan banyak sheet [1 Attachment]
Dear Para Master,Suhu & Sesepuh Belajar-Excel,Di Bulan yang penuh berkah
ini ijinkan saya mohon pencerahannya , Bagaimana membuat rumus penjumlahan
gabungan antara beberapa sheet yang berbeda tetapi dengan kode item yang sama.
Berikut ini adalah contoh sedikit karena data sebenarnya ada 20 sheet lebih.
Atas bantuan pemikirannya saya ucapkan Matur Nuwun Sanget.Semoga Amal dan
ibadah di jadikan amalah saleh oleh Alloh SWT Amin… Salam Member Setia,Guswi
#yiv2587641292 #yiv2587641292 -- #yiv2587641292ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2587641292
#yiv2587641292ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2587641292
#yiv2587641292ygrp-mkp #yiv2587641292hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2587641292 #yiv2587641292ygrp-mkp #yiv2587641292ads
{margin-bottom:10px;}#yiv2587641292 #yiv2587641292ygrp-mkp .yiv2587641292ad
{padding:0 0;}#yiv2587641292 #yiv2587641292ygrp-mkp .yiv2587641292ad p
{margin:0;}#yiv2587641292 #yiv2587641292ygrp-mkp .yiv2587641292ad a
{color:#0000ff;text-decoration:none;}#yiv2587641292 #yiv2587641292ygrp-sponsor
#yiv2587641292ygrp-lc {font-family:Arial;}#yiv2587641292
#yiv2587641292ygrp-sponsor #yiv2587641292ygrp-lc #yiv2587641292hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2587641292
#yiv2587641292ygrp-sponsor #yiv2587641292ygrp-lc .yiv2587641292ad
{margin-bottom:10px;padding:0 0;}#yiv2587641292 #yiv2587641292actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2587641292
#yiv2587641292activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2587641292
#yiv2587641292activity span {font-weight:700;}#yiv2587641292
#yiv2587641292activity span:first-child
{text-transform:uppercase;}#yiv2587641292 #yiv2587641292activity span a
{color:#5085b6;text-decoration:none;}#yiv2587641292 #yiv2587641292activity span
span {color:#ff7900;}#yiv2587641292 #yiv2587641292activity span
.yiv2587641292underline {text-decoration:underline;}#yiv2587641292
.yiv2587641292attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;min-width:400px;}#yiv2587641292 .yiv2587641292attach div a
{text-decoration:none;}#yiv2587641292 .yiv2587641292attach img
{border:none;padding-right:5px;}#yiv2587641292 .yiv2587641292attach label
{display:block;margin-bottom:5px;}#yiv2587641292 .yiv2587641292attach label a
{text-decoration:none;}#yiv2587641292 blockquote {margin:0 0 0
4px;}#yiv2587641292 .yiv2587641292bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2587641292
.yiv2587641292bold a {text-decoration:none;}#yiv2587641292 dd.yiv2587641292last
p a {font-family:Verdana;font-weight:700;}#yiv2587641292 dd.yiv2587641292last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2587641292
dd.yiv2587641292last p span.yiv2587641292yshortcuts
{margin-right:0;}#yiv2587641292 div.yiv2587641292attach-table div div a
{text-decoration:none;}#yiv2587641292 div.yiv2587641292attach-table
{min-width:400px;}#yiv2587641292 div.yiv2587641292file-title a, #yiv2587641292
div.yiv2587641292file-title a:active, #yiv2587641292
div.yiv2587641292file-title a:hover, #yiv2587641292 div.yiv2587641292file-title
a:visited {text-decoration:none;}#yiv2587641292 div.yiv2587641292photo-title a,
#yiv2587641292 div.yiv2587641292photo-title a:active, #yiv2587641292
div.yiv2587641292photo-title a:hover, #yiv2587641292
div.yiv2587641292photo-title a:visited {text-decoration:none;}#yiv2587641292
div#yiv2587641292ygrp-mlmsg #yiv2587641292ygrp-msg p a
span.yiv2587641292yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2587641292
.yiv2587641292green {color:#628c2a;}#yiv2587641292 .yiv2587641292MsoNormal
{margin:0 0 0 0;}#yiv2587641292 o {font-size:0;}#yiv2587641292
#yiv2587641292photos div {float:left;min-width:72px;}#yiv2587641292
#yiv2587641292photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;min-width:62px;}#yiv2587641292
#yiv2587641292photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;min-width:64px;}#yiv2587641292
#yiv2587641292reco-category {font-size:77%;}#yiv2587641292
#yiv2587641292reco-desc {font-size:77%;}#yiv2587641292 .yiv2587641292replbq
{margin:4px;}#yiv2587641292 #yiv2587641292ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2587641292 #yiv2587641292ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2587641292
#yiv2587641292ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2587641292
#yiv2587641292ygrp-mlmsg select, #yiv2587641292 input, #yiv2587641292 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2587641292
#yiv2587641292ygrp-mlmsg pre, #yiv2587641292 code {font:115%
monospace;}#yiv2587641292 #yiv2587641292ygrp-mlmsg *
{line-height:1.22em;}#yiv2587641292 #yiv2587641292ygrp-mlmsg #yiv2587641292logo
{padding-bottom:10px;}#yiv2587641292 #yiv2587641292ygrp-msg p a
{font-family:Verdana;}#yiv2587641292 #yiv2587641292ygrp-msg
p#yiv2587641292attach-count span {color:#1E66AE;font-weight:700;}#yiv2587641292
#yiv2587641292ygrp-reco #yiv2587641292reco-head
{color:#ff7900;font-weight:700;}#yiv2587641292 #yiv2587641292ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2587641292 #yiv2587641292ygrp-sponsor
#yiv2587641292ov li a {font-size:130%;text-decoration:none;}#yiv2587641292
#yiv2587641292ygrp-sponsor #yiv2587641292ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2587641292
#yiv2587641292ygrp-sponsor #yiv2587641292ov ul {margin:0;padding:0 0 0
8px;}#yiv2587641292 #yiv2587641292ygrp-text
{font-family:Georgia;}#yiv2587641292 #yiv2587641292ygrp-text p {margin:0 0 1em
0;}#yiv2587641292 #yiv2587641292ygrp-text tt {font-size:120%;}#yiv2587641292
#yiv2587641292ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2587641292
re_tanya+rumus+gabungan (1).xlsx
Description: MS-Excel 2007 spreadsheet
