di F10
=SUMIF($C$4:$T$4,E10,$C$5:$T$5)
copy ke bawah
wassalam
ghozi alkatiri
Pada Jumat, 13 April 2018 10.41.18 GMT+7, odong nando odongna...@yahoo.com
[belajar-excel] menulis:
sangat bisa, bila anda terbiasa menggunakan fungsi sumif ini yang biasa nya
kebawah jadi kesamping saja utk range dan sum range nya..
silakan di coba... br,
odong nando
Dari: "Wahyu Eko abi_esc...@yahoo.com [belajar-excel]"
Kepada: belajar-excel@yahoogroups.com
Dikirim: Jumat, 13 April 2018 10:29
Judul: [belajar-excel] Penggunaan formula SUMIF untuk data Horisontal [1
Attachment]
Assalamu alaikum Wr. Wb.
Saya ingin meminta bantuan ke teman teman Be Exceler tentang penggunaan Formula
SUMIF untuk data Horisontal. BIsa atau tidak? Saya mengalami kendala mengenai
hal tersebut. saya harap teman2 be Exceler bersedia untuk membantu.File
Terlampir.
Sebelumnya saya ucapkan banyak terima kasih..
Wassalam.
#yiv2972054525 #yiv2972054525 -- #yiv2972054525ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2972054525
#yiv2972054525ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2972054525
#yiv2972054525ygrp-mkp #yiv2972054525hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2972054525 #yiv2972054525ygrp-mkp #yiv2972054525ads
{margin-bottom:10px;}#yiv2972054525 #yiv2972054525ygrp-mkp ..yiv2972054525ad
{padding:0 0;}#yiv2972054525 #yiv2972054525ygrp-mkp .yiv2972054525ad p
{margin:0;}#yiv2972054525 #yiv2972054525ygrp-mkp .yiv2972054525ad a
{color:#ff;text-decoration:none;}#yiv2972054525 #yiv2972054525ygrp-sponsor
#yiv2972054525ygrp-lc {font-family:Arial;}#yiv2972054525
#yiv2972054525ygrp-sponsor #yiv2972054525ygrp-lc #yiv2972054525hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2972054525
#yiv2972054525ygrp-sponsor #yiv2972054525ygrp-lc .yiv2972054525ad
{margin-bottom:10px;padding:0 0;}#yiv2972054525 #yiv2972054525actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2972054525
#yiv2972054525activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2972054525
#yiv2972054525activity span {font-weight:700;}#yiv2972054525
#yiv2972054525activity span:first-child
{text-transform:uppercase;}#yiv2972054525 #yiv2972054525activity span a
{color:#5085b6;text-decoration:none;}#yiv2972054525 #yiv2972054525activity span
span {color:#ff7900;}#yiv2972054525 #yiv2972054525activity span
.yiv2972054525underline {text-decoration:underline;}#yiv2972054525
.yiv2972054525attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2972054525 .yiv2972054525attach div a
{text-decoration:none;}#yiv2972054525 .yiv2972054525attach img
{border:none;padding-right:5px;}#yiv2972054525 .yiv2972054525attach label
{display:block;margin-bottom:5px;}#yiv2972054525 .yiv2972054525attach label a
{text-decoration:none;}#yiv2972054525 blockquote {margin:0 0 0
4px;}#yiv2972054525 .yiv2972054525bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2972054525
.yiv2972054525bold a {text-decoration:none;}#yiv2972054525 dd.yiv2972054525last
p a {font-family:Verdana;font-weight:700;}#yiv2972054525 dd.yiv2972054525last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2972054525
dd.yiv2972054525last p span.yiv2972054525yshortcuts
{margin-right:0;}#yiv2972054525 div.yiv2972054525attach-table div div a
{text-decoration:none;}#yiv2972054525 div.yiv2972054525attach-table
{width:400px;}#yiv2972054525 div.yiv2972054525file-title a, #yiv2972054525
div.yiv2972054525file-title a:active, #yiv2972054525
div.yiv2972054525file-title a:hover, #yiv2972054525 div.yiv2972054525file-title
a:visited {text-decoration:none;}#yiv2972054525 div.yiv2972054525photo-title a,
#yiv2972054525 div.yiv2972054525photo-title a:active, #yiv2972054525
div.yiv2972054525photo-title a:hover, #yiv2972054525
div.yiv2972054525photo-title a:visited {text-decoration:none;}#yiv2972054525
div#yiv2972054525ygrp-mlmsg #yiv2972054525ygrp-msg p a
span.yiv2972054525yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2972054525
.yiv2972054525green {color:#628c2a;}#yiv2972054525 .yiv2972054525MsoNormal
{margin:0 0 0 0;}#yiv2972054525 o {font-size:0;}#yiv2972054525
#yiv2972054525photos div {float:left;width:72px;}#yiv2972054525
#yiv2972054525photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2972054525
#yiv2972054525photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2972054525
#yiv2972054525reco-category {font-size:77%;}#yiv2972054525
#yiv2972054525reco-desc {font-size:77%;}#yiv2972054525 .yiv2972054525replbq
{margin:4px;}#yiv2972054525 #yiv2972054525ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2972054525 #yiv2972054525ygrp-mlmsg