Hai Fatania,Jawaban terlampir menggunakan kolom bantu.
Salam,HK
From: "Fatania Latifa fatania.lat...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, 30 December 2016, 11:33
Subject: [belajar-excel] Tanya Rumus Penjumlahan Tidak Langsung [1 Attachment]
Dear Suhu2 Excel,
Saya ingin tanya,
Bagaimana rumus di kolom hasil agar hasilnya otomatis keluar hanya dengan
input kolom Awal dan Akhir??
Saya sudah mencoba menggunakan kombinasi choose dan indirect tetapi hasilnya
tidak keluar.
Mohon pencerahannya.
#yiv8063574192 #yiv8063574192 -- #yiv8063574192ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8063574192
#yiv8063574192ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8063574192
#yiv8063574192ygrp-mkp #yiv8063574192hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8063574192 #yiv8063574192ygrp-mkp #yiv8063574192ads
{margin-bottom:10px;}#yiv8063574192 #yiv8063574192ygrp-mkp .yiv8063574192ad
{padding:0 0;}#yiv8063574192 #yiv8063574192ygrp-mkp .yiv8063574192ad p
{margin:0;}#yiv8063574192 #yiv8063574192ygrp-mkp .yiv8063574192ad a
{color:#0000ff;text-decoration:none;}#yiv8063574192 #yiv8063574192ygrp-sponsor
#yiv8063574192ygrp-lc {font-family:Arial;}#yiv8063574192
#yiv8063574192ygrp-sponsor #yiv8063574192ygrp-lc #yiv8063574192hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8063574192
#yiv8063574192ygrp-sponsor #yiv8063574192ygrp-lc .yiv8063574192ad
{margin-bottom:10px;padding:0 0;}#yiv8063574192 #yiv8063574192actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8063574192
#yiv8063574192activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8063574192
#yiv8063574192activity span {font-weight:700;}#yiv8063574192
#yiv8063574192activity span:first-child
{text-transform:uppercase;}#yiv8063574192 #yiv8063574192activity span a
{color:#5085b6;text-decoration:none;}#yiv8063574192 #yiv8063574192activity span
span {color:#ff7900;}#yiv8063574192 #yiv8063574192activity span
.yiv8063574192underline {text-decoration:underline;}#yiv8063574192
.yiv8063574192attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8063574192 .yiv8063574192attach div a
{text-decoration:none;}#yiv8063574192 .yiv8063574192attach img
{border:none;padding-right:5px;}#yiv8063574192 .yiv8063574192attach label
{display:block;margin-bottom:5px;}#yiv8063574192 .yiv8063574192attach label a
{text-decoration:none;}#yiv8063574192 blockquote {margin:0 0 0
4px;}#yiv8063574192 .yiv8063574192bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8063574192
.yiv8063574192bold a {text-decoration:none;}#yiv8063574192 dd.yiv8063574192last
p a {font-family:Verdana;font-weight:700;}#yiv8063574192 dd.yiv8063574192last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8063574192
dd.yiv8063574192last p span.yiv8063574192yshortcuts
{margin-right:0;}#yiv8063574192 div.yiv8063574192attach-table div div a
{text-decoration:none;}#yiv8063574192 div.yiv8063574192attach-table
{width:400px;}#yiv8063574192 div.yiv8063574192file-title a, #yiv8063574192
div.yiv8063574192file-title a:active, #yiv8063574192
div.yiv8063574192file-title a:hover, #yiv8063574192 div.yiv8063574192file-title
a:visited {text-decoration:none;}#yiv8063574192 div.yiv8063574192photo-title a,
#yiv8063574192 div.yiv8063574192photo-title a:active, #yiv8063574192
div.yiv8063574192photo-title a:hover, #yiv8063574192
div.yiv8063574192photo-title a:visited {text-decoration:none;}#yiv8063574192
div#yiv8063574192ygrp-mlmsg #yiv8063574192ygrp-msg p a
span.yiv8063574192yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8063574192
.yiv8063574192green {color:#628c2a;}#yiv8063574192 .yiv8063574192MsoNormal
{margin:0 0 0 0;}#yiv8063574192 o {font-size:0;}#yiv8063574192
#yiv8063574192photos div {float:left;width:72px;}#yiv8063574192
#yiv8063574192photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8063574192
#yiv8063574192photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8063574192
#yiv8063574192reco-category {font-size:77%;}#yiv8063574192
#yiv8063574192reco-desc {font-size:77%;}#yiv8063574192 .yiv8063574192replbq
{margin:4px;}#yiv8063574192 #yiv8063574192ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8063574192 #yiv8063574192ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8063574192
#yiv8063574192ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8063574192
#yiv8063574192ygrp-mlmsg select, #yiv8063574192 input, #yiv8063574192 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8063574192
#yiv8063574192ygrp-mlmsg pre, #yiv8063574192 code {font:115%
monospace;}#yiv8063574192 #yiv8063574192ygrp-mlmsg *
{line-height:1.22em;}#yiv8063574192 #yiv8063574192ygrp-mlmsg #yiv8063574192logo
{padding-bottom:10px;}#yiv8063574192 #yiv8063574192ygrp-msg p a
{font-family:Verdana;}#yiv8063574192 #yiv8063574192ygrp-msg
p#yiv8063574192attach-count span {color:#1E66AE;font-weight:700;}#yiv8063574192
#yiv8063574192ygrp-reco #yiv8063574192reco-head
{color:#ff7900;font-weight:700;}#yiv8063574192 #yiv8063574192ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8063574192 #yiv8063574192ygrp-sponsor
#yiv8063574192ov li a {font-size:130%;text-decoration:none;}#yiv8063574192
#yiv8063574192ygrp-sponsor #yiv8063574192ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8063574192
#yiv8063574192ygrp-sponsor #yiv8063574192ov ul {margin:0;padding:0 0 0
8px;}#yiv8063574192 #yiv8063574192ygrp-text
{font-family:Georgia;}#yiv8063574192 #yiv8063574192ygrp-text p {margin:0 0 1em
0;}#yiv8063574192 #yiv8063574192ygrp-text tt {font-size:120%;}#yiv8063574192
#yiv8063574192ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8063574192
re_Rumus Penjumlahan Otomatis.xlsx
Description: MS-Excel 2007 spreadsheet
