Mas Lukman,
Terima kasih bantuannya akhirnya bisa juga.
Salam,Tono
Pada Kamis, 14 Desember 2017 15.43.07 GMT+8, Pak Cik Lukman
pakcikluk...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Dear mas Tono,
coba di hilangkan tanda " pada formula IF-nya
salam,
Pada 14 Desember 2017 10.01, Hartono Tono tonoharton...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:
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
#yiv2657821523 #yiv2657821523 -- #yiv2657821523ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2657821523
#yiv2657821523ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2657821523
#yiv2657821523ygrp-mkp #yiv2657821523hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2657821523 #yiv2657821523ygrp-mkp #yiv2657821523ads
{margin-bottom:10px;}#yiv2657821523 #yiv2657821523ygrp-mkp .yiv2657821523ad
{padding:0 0;}#yiv2657821523 #yiv2657821523ygrp-mkp .yiv2657821523ad p
{margin:0;}#yiv2657821523 #yiv2657821523ygrp-mkp .yiv2657821523ad a
{color:#0000ff;text-decoration:none;}#yiv2657821523 #yiv2657821523ygrp-sponsor
#yiv2657821523ygrp-lc {font-family:Arial;}#yiv2657821523
#yiv2657821523ygrp-sponsor #yiv2657821523ygrp-lc #yiv2657821523hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2657821523
#yiv2657821523ygrp-sponsor #yiv2657821523ygrp-lc .yiv2657821523ad
{margin-bottom:10px;padding:0 0;}#yiv2657821523 #yiv2657821523actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2657821523
#yiv2657821523activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2657821523
#yiv2657821523activity span {font-weight:700;}#yiv2657821523
#yiv2657821523activity span:first-child
{text-transform:uppercase;}#yiv2657821523 #yiv2657821523activity span a
{color:#5085b6;text-decoration:none;}#yiv2657821523 #yiv2657821523activity span
span {color:#ff7900;}#yiv2657821523 #yiv2657821523activity span
.yiv2657821523underline {text-decoration:underline;}#yiv2657821523
.yiv2657821523attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2657821523 .yiv2657821523attach div a
{text-decoration:none;}#yiv2657821523 .yiv2657821523attach img
{border:none;padding-right:5px;}#yiv2657821523 .yiv2657821523attach label
{display:block;margin-bottom:5px;}#yiv2657821523 .yiv2657821523attach label a
{text-decoration:none;}#yiv2657821523 blockquote {margin:0 0 0
4px;}#yiv2657821523 .yiv2657821523bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2657821523
.yiv2657821523bold a {text-decoration:none;}#yiv2657821523 dd.yiv2657821523last
p a {font-family:Verdana;font-weight:700;}#yiv2657821523 dd.yiv2657821523last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2657821523
dd.yiv2657821523last p span.yiv2657821523yshortcuts
{margin-right:0;}#yiv2657821523 div.yiv2657821523attach-table div div a
{text-decoration:none;}#yiv2657821523 div.yiv2657821523attach-table
{width:400px;}#yiv2657821523 div.yiv2657821523file-title a, #yiv2657821523
div.yiv2657821523file-title a:active, #yiv2657821523
div.yiv2657821523file-title a:hover, #yiv2657821523 div.yiv2657821523file-title
a:visited {text-decoration:none;}#yiv2657821523 div.yiv2657821523photo-title a,
#yiv2657821523 div.yiv2657821523photo-title a:active, #yiv2657821523
div.yiv2657821523photo-title a:hover, #yiv2657821523
div.yiv2657821523photo-title a:visited {text-decoration:none;}#yiv2657821523
div#yiv2657821523ygrp-mlmsg #yiv2657821523ygrp-msg p a
span.yiv2657821523yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2657821523
.yiv2657821523green {color:#628c2a;}#yiv2657821523 .yiv2657821523MsoNormal
{margin:0 0 0 0;}#yiv2657821523 o {font-size:0;}#yiv2657821523
#yiv2657821523photos div {float:left;width:72px;}#yiv2657821523
#yiv2657821523photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2657821523
#yiv2657821523photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2657821523
#yiv2657821523reco-category {font-size:77%;}#yiv2657821523
#yiv2657821523reco-desc {font-size:77%;}#yiv2657821523 .yiv2657821523replbq
{margin:4px;}#yiv2657821523 #yiv2657821523ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2657821523 #yiv2657821523ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2657821523
#yiv2657821523ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2657821523
#yiv2657821523ygrp-mlmsg select, #yiv2657821523 input, #yiv2657821523 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2657821523
#yiv2657821523ygrp-mlmsg pre, #yiv2657821523 code {font:115%
monospace;}#yiv2657821523 #yiv2657821523ygrp-mlmsg *
{line-height:1.22em;}#yiv2657821523 #yiv2657821523ygrp-mlmsg #yiv2657821523logo
{padding-bottom:10px;}#yiv2657821523 #yiv2657821523ygrp-msg p a
{font-family:Verdana;}#yiv2657821523 #yiv2657821523ygrp-msg
p#yiv2657821523attach-count span {color:#1E66AE;font-weight:700;}#yiv2657821523
#yiv2657821523ygrp-reco #yiv2657821523reco-head
{color:#ff7900;font-weight:700;}#yiv2657821523 #yiv2657821523ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2657821523 #yiv2657821523ygrp-sponsor
#yiv2657821523ov li a {font-size:130%;text-decoration:none;}#yiv2657821523
#yiv2657821523ygrp-sponsor #yiv2657821523ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2657821523
#yiv2657821523ygrp-sponsor #yiv2657821523ov ul {margin:0;padding:0 0 0
8px;}#yiv2657821523 #yiv2657821523ygrp-text
{font-family:Georgia;}#yiv2657821523 #yiv2657821523ygrp-text p {margin:0 0 1em
0;}#yiv2657821523 #yiv2657821523ygrp-text tt {font-size:120%;}#yiv2657821523
#yiv2657821523ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2657821523
