ciba kasih ABS( ) deh di luar IF nya br,
odong nando
Dari: "Hartono Tono tonoharton...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 14 Desember 2017 14:24
Judul: [belajar-excel] Menjumlahkan hasil IF bertingkat
To All Master,
Mohon bantuannya saya menggunakan IF bertingkat untuk mencari kriteria yang
saya mau namun ketika ingin menjumlahkan hasil dari rumus IF tersebut hasilnya
selalu saja 0. Tolong dibantu master bagaimana caranya untuk menjumlahkannya
untuk lebih jelasnya bisa dilihat pada file terlampir.Terima kasih atas
bantuannya.
Salam,Tono #yiv9950622712 #yiv9950622712 -- #yiv9950622712ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9950622712
#yiv9950622712ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9950622712
#yiv9950622712ygrp-mkp #yiv9950622712hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9950622712 #yiv9950622712ygrp-mkp #yiv9950622712ads
{margin-bottom:10px;}#yiv9950622712 #yiv9950622712ygrp-mkp .yiv9950622712ad
{padding:0 0;}#yiv9950622712 #yiv9950622712ygrp-mkp .yiv9950622712ad p
{margin:0;}#yiv9950622712 #yiv9950622712ygrp-mkp .yiv9950622712ad a
{color:#0000ff;text-decoration:none;}#yiv9950622712 #yiv9950622712ygrp-sponsor
#yiv9950622712ygrp-lc {font-family:Arial;}#yiv9950622712
#yiv9950622712ygrp-sponsor #yiv9950622712ygrp-lc #yiv9950622712hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9950622712
#yiv9950622712ygrp-sponsor #yiv9950622712ygrp-lc .yiv9950622712ad
{margin-bottom:10px;padding:0 0;}#yiv9950622712 #yiv9950622712actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9950622712
#yiv9950622712activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9950622712
#yiv9950622712activity span {font-weight:700;}#yiv9950622712
#yiv9950622712activity span:first-child
{text-transform:uppercase;}#yiv9950622712 #yiv9950622712activity span a
{color:#5085b6;text-decoration:none;}#yiv9950622712 #yiv9950622712activity span
span {color:#ff7900;}#yiv9950622712 #yiv9950622712activity span
.yiv9950622712underline {text-decoration:underline;}#yiv9950622712
.yiv9950622712attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9950622712 .yiv9950622712attach div a
{text-decoration:none;}#yiv9950622712 .yiv9950622712attach img
{border:none;padding-right:5px;}#yiv9950622712 .yiv9950622712attach label
{display:block;margin-bottom:5px;}#yiv9950622712 .yiv9950622712attach label a
{text-decoration:none;}#yiv9950622712 blockquote {margin:0 0 0
4px;}#yiv9950622712 .yiv9950622712bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9950622712
.yiv9950622712bold a {text-decoration:none;}#yiv9950622712 dd.yiv9950622712last
p a {font-family:Verdana;font-weight:700;}#yiv9950622712 dd.yiv9950622712last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9950622712
dd.yiv9950622712last p span.yiv9950622712yshortcuts
{margin-right:0;}#yiv9950622712 div.yiv9950622712attach-table div div a
{text-decoration:none;}#yiv9950622712 div.yiv9950622712attach-table
{width:400px;}#yiv9950622712 div.yiv9950622712file-title a, #yiv9950622712
div.yiv9950622712file-title a:active, #yiv9950622712
div.yiv9950622712file-title a:hover, #yiv9950622712 div.yiv9950622712file-title
a:visited {text-decoration:none;}#yiv9950622712 div.yiv9950622712photo-title a,
#yiv9950622712 div.yiv9950622712photo-title a:active, #yiv9950622712
div.yiv9950622712photo-title a:hover, #yiv9950622712
div.yiv9950622712photo-title a:visited {text-decoration:none;}#yiv9950622712
div#yiv9950622712ygrp-mlmsg #yiv9950622712ygrp-msg p a
span.yiv9950622712yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9950622712
.yiv9950622712green {color:#628c2a;}#yiv9950622712 .yiv9950622712MsoNormal
{margin:0 0 0 0;}#yiv9950622712 o {font-size:0;}#yiv9950622712
#yiv9950622712photos div {float:left;width:72px;}#yiv9950622712
#yiv9950622712photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9950622712
#yiv9950622712photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9950622712
#yiv9950622712reco-category {font-size:77%;}#yiv9950622712
#yiv9950622712reco-desc {font-size:77%;}#yiv9950622712 .yiv9950622712replbq
{margin:4px;}#yiv9950622712 #yiv9950622712ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9950622712 #yiv9950622712ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9950622712
#yiv9950622712ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9950622712
#yiv9950622712ygrp-mlmsg select, #yiv9950622712 input, #yiv9950622712 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9950622712
#yiv9950622712ygrp-mlmsg pre, #yiv9950622712 code {font:115%
monospace;}#yiv9950622712 #yiv9950622712ygrp-mlmsg *
{line-height:1.22em;}#yiv9950622712 #yiv9950622712ygrp-mlmsg #yiv9950622712logo
{padding-bottom:10px;}#yiv9950622712 #yiv9950622712ygrp-msg p a
{font-family:Verdana;}#yiv9950622712 #yiv9950622712ygrp-msg
p#yiv9950622712attach-count span {color:#1E66AE;font-weight:700;}#yiv9950622712
#yiv9950622712ygrp-reco #yiv9950622712reco-head
{color:#ff7900;font-weight:700;}#yiv9950622712 #yiv9950622712ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9950622712 #yiv9950622712ygrp-sponsor
#yiv9950622712ov li a {font-size:130%;text-decoration:none;}#yiv9950622712
#yiv9950622712ygrp-sponsor #yiv9950622712ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9950622712
#yiv9950622712ygrp-sponsor #yiv9950622712ov ul {margin:0;padding:0 0 0
8px;}#yiv9950622712 #yiv9950622712ygrp-text
{font-family:Georgia;}#yiv9950622712 #yiv9950622712ygrp-text p {margin:0 0 1em
0;}#yiv9950622712 #yiv9950622712ygrp-text tt {font-size:120%;}#yiv9950622712
#yiv9950622712ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9950622712
