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] <belajar-excel@yahoogroups.com> 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]" 
<belajar-excel@yahoogroups.com>
 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:#0000ff;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 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2972054525 
#yiv2972054525photos div label 
{color:#666666;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 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2972054525 
#yiv2972054525ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2972054525 
#yiv2972054525ygrp-mlmsg select, #yiv2972054525 input, #yiv2972054525 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2972054525 
#yiv2972054525ygrp-mlmsg pre, #yiv2972054525 code {font:115% 
monospace;}#yiv2972054525 #yiv2972054525ygrp-mlmsg * 
{line-height:1.22em;}#yiv2972054525 #yiv2972054525ygrp-mlmsg #yiv2972054525logo 
{padding-bottom:10px;}#yiv2972054525 #yiv2972054525ygrp-msg p a 
{font-family:Verdana;}#yiv2972054525 #yiv2972054525ygrp-msg 
p#yiv2972054525attach-count span {color:#1E66AE;font-weight:700;}#yiv2972054525 
#yiv2972054525ygrp-reco #yiv2972054525reco-head 
{color:#ff7900;font-weight:700;}#yiv2972054525 #yiv2972054525ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv2972054525 #yiv2972054525ygrp-sponsor 
#yiv2972054525ov li a {font-size:130%;text-decoration:none;}#yiv2972054525 
#yiv2972054525ygrp-sponsor #yiv2972054525ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2972054525 
#yiv2972054525ygrp-sponsor #yiv2972054525ov ul {margin:0;padding:0 0 0 
8px;}#yiv2972054525 #yiv2972054525ygrp-text 
{font-family:Georgia;}#yiv2972054525 #yiv2972054525ygrp-text p {margin:0 0 1em 
0;}#yiv2972054525 #yiv2972054525ygrp-text tt {font-size:120%;}#yiv2972054525 
#yiv2972054525ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv2972054525   
  • Bls: [belajar-exc... odong nando odongna...@yahoo.com [belajar-excel]
    • RE: [belajar... 'M.Ade Alfarid' q...@kkmi.co.id [belajar-excel]
    • Re: Bls: [be... ghozi alkatiri ghozialkat...@yahoo.co.id [belajar-excel]
      • Re: Bls:... NangAgus nanga...@gmail.com [belajar-excel]

Kirim email ke