[belajar-excel] Summary Quaterly sales [1 Attachment]

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] Summary Quaterly sales [1 Attachment]

Milis Belajar Excel mailing list
Dear para Master,
Ini saya mau mohon bantuan dari master2 semua
Sebelunya saya ucapakan terima kasih bayak
Salam Sejahtera,Kasuma

summary Quater sales.xlsx (13K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Summary Quaterly sales

Milis Belajar Excel mailing list
Hai Kasuma,Pakai formula biasa saja...=x+y+zkemudian copy ke bawah dan kesamping.
Salam,HK

Sent from Yahoo Mail on Android
 
  On Tue, Jun 27, 2017 at 18:38, BOBY CHUA [hidden email] [belajar-excel]<[hidden email]> wrote:      

Dear para Master,
Ini saya mau mohon bantuan dari master2 semua
Sebelunya saya ucapakan terima kasih bayak
Salam Sejahtera,Kasuma
  #yiv3859144822 #yiv3859144822 -- #yiv3859144822ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3859144822 #yiv3859144822ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3859144822 #yiv3859144822ygrp-mkp #yiv3859144822hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3859144822 #yiv3859144822ygrp-mkp #yiv3859144822ads {margin-bottom:10px;}#yiv3859144822 #yiv3859144822ygrp-mkp .yiv3859144822ad {padding:0 0;}#yiv3859144822 #yiv3859144822ygrp-mkp .yiv3859144822ad p {margin:0;}#yiv3859144822 #yiv3859144822ygrp-mkp .yiv3859144822ad a {color:#0000ff;text-decoration:none;}#yiv3859144822 #yiv3859144822ygrp-sponsor #yiv3859144822ygrp-lc {font-family:Arial;}#yiv3859144822 #yiv3859144822ygrp-sponsor #yiv3859144822ygrp-lc #yiv3859144822hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3859144822 #yiv3859144822ygrp-sponsor #yiv3859144822ygrp-lc .yiv3859144822ad {margin-bottom:10px;padding:0 0;}#yiv3859144822 #yiv3859144822actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3859144822 #yiv3859144822activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3859144822 #yiv3859144822activity span {font-weight:700;}#yiv3859144822 #yiv3859144822activity span:first-child {text-transform:uppercase;}#yiv3859144822 #yiv3859144822activity span a {color:#5085b6;text-decoration:none;}#yiv3859144822 #yiv3859144822activity span span {color:#ff7900;}#yiv3859144822 #yiv3859144822activity span .yiv3859144822underline {text-decoration:underline;}#yiv3859144822 .yiv3859144822attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3859144822 .yiv3859144822attach div a {text-decoration:none;}#yiv3859144822 .yiv3859144822attach img {border:none;padding-right:5px;}#yiv3859144822 .yiv3859144822attach label {display:block;margin-bottom:5px;}#yiv3859144822 .yiv3859144822attach label a {text-decoration:none;}#yiv3859144822 blockquote {margin:0 0 0 4px;}#yiv3859144822 .yiv3859144822bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3859144822 .yiv3859144822bold a {text-decoration:none;}#yiv3859144822 dd.yiv3859144822last p a {font-family:Verdana;font-weight:700;}#yiv3859144822 dd.yiv3859144822last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3859144822 dd.yiv3859144822last p span.yiv3859144822yshortcuts {margin-right:0;}#yiv3859144822 div.yiv3859144822attach-table div div a {text-decoration:none;}#yiv3859144822 div.yiv3859144822attach-table {width:400px;}#yiv3859144822 div.yiv3859144822file-title a, #yiv3859144822 div.yiv3859144822file-title a:active, #yiv3859144822 div.yiv3859144822file-title a:hover, #yiv3859144822 div.yiv3859144822file-title a:visited {text-decoration:none;}#yiv3859144822 div.yiv3859144822photo-title a, #yiv3859144822 div.yiv3859144822photo-title a:active, #yiv3859144822 div.yiv3859144822photo-title a:hover, #yiv3859144822 div.yiv3859144822photo-title a:visited {text-decoration:none;}#yiv3859144822 div#yiv3859144822ygrp-mlmsg #yiv3859144822ygrp-msg p a span.yiv3859144822yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3859144822 .yiv3859144822green {color:#628c2a;}#yiv3859144822 .yiv3859144822MsoNormal {margin:0 0 0 0;}#yiv3859144822 o {font-size:0;}#yiv3859144822 #yiv3859144822photos div {float:left;width:72px;}#yiv3859144822 #yiv3859144822photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3859144822 #yiv3859144822photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3859144822 #yiv3859144822reco-category {font-size:77%;}#yiv3859144822 #yiv3859144822reco-desc {font-size:77%;}#yiv3859144822 .yiv3859144822replbq {margin:4px;}#yiv3859144822 #yiv3859144822ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3859144822 #yiv3859144822ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3859144822 #yiv3859144822ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3859144822 #yiv3859144822ygrp-mlmsg select, #yiv3859144822 input, #yiv3859144822 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3859144822 #yiv3859144822ygrp-mlmsg pre, #yiv3859144822 code {font:115% monospace;}#yiv3859144822 #yiv3859144822ygrp-mlmsg * {line-height:1.22em;}#yiv3859144822 #yiv3859144822ygrp-mlmsg #yiv3859144822logo {padding-bottom:10px;}#yiv3859144822 #yiv3859144822ygrp-msg p a {font-family:Verdana;}#yiv3859144822 #yiv3859144822ygrp-msg p#yiv3859144822attach-count span {color:#1E66AE;font-weight:700;}#yiv3859144822 #yiv3859144822ygrp-reco #yiv3859144822reco-head {color:#ff7900;font-weight:700;}#yiv3859144822 #yiv3859144822ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3859144822 #yiv3859144822ygrp-sponsor #yiv3859144822ov li a {font-size:130%;text-decoration:none;}#yiv3859144822 #yiv3859144822ygrp-sponsor #yiv3859144822ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3859144822 #yiv3859144822ygrp-sponsor #yiv3859144822ov ul {margin:0;padding:0 0 0 8px;}#yiv3859144822 #yiv3859144822ygrp-text {font-family:Georgia;}#yiv3859144822 #yiv3859144822ygrp-text p {margin:0 0 1em 0;}#yiv3859144822 #yiv3859144822ygrp-text tt {font-size:120%;}#yiv3859144822 #yiv3859144822ygrp-vital ul li:last-child {border-right:none !important;}#yiv3859144822  
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Summary Quaterly sales

Milis Belajar Excel mailing list
In reply to this post by Milis Belajar Excel mailing list
Dear Boby Chua

di B14 dapat menggunakan formula:
=SUMPRODUCT(($B5:$M5)*($B$4:$M$4=B$13))

tetapi lebih sederhana usulan rumus pak Hendrik:

=B5+F5+J5

copy ke kiri dan ke bawah

salam

Agus



On 6/27/17 3:45 PM, BOBY CHUA [hidden email] [belajar-excel] wrote:
> Dear para Master,
>
> Ini saya mau mohon bantuan dari master2 semua
>
> Sebelunya saya ucapakan terima kasih bayak
>
> Salam Sejahtera,
> Kasuma
>

Loading...