waalaikumsalam warahmatullahi wabarakatuh,
hai iman,
saya sih ga tau ya gmn program xcelsius, tp sepanjang bisa menggunakan array
formula yg biasa klo formula di excel diahiri dgn ctrl+shif enter, mungkin bisa
pake sum yang di padukan dgn if....
=SUM(IF($B$9:$B$17=$C$4;IF($C$9:$C$17=$C$5;IF($D$8:$O$8=D$3;$D$9:$O$17))))
array formula yang diahiri dgn ctrl+shif enter
ganti karakter titik koma ";" dengan koma "," jika regional setingnya english
mungkin bisa di coba, klo berhasil info ya, sebelum para master excel
bertitah...hehe... br,
odong nando
Dari: "[email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Selasa, 8 Januari 2019 10:20
Judul: [belajar-excel] Xcelsius Multiple Criteria [1 Attachment]
Assalammualaikum warahamatullah wabarakatuh,
mohon bantuannya, saya lagi buat dashboard di program Xcelsius.Xcelsius ini
banyak sekali tidak support dengan rumus2.
nah saya ada contoh multiple criteria yang biasanya saya pakai SUMPRODUCT
ataupun SUMIFS, sayangnya untuk Xcelsius dia tidak support, saya mau tanya
apakah ada logic lain yang bisa dibaca/support oleh Xcelsius?
salamIman #yiv3255654038 #yiv3255654038 -- #yiv3255654038ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3255654038
#yiv3255654038ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3255654038
#yiv3255654038ygrp-mkp #yiv3255654038hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3255654038 #yiv3255654038ygrp-mkp #yiv3255654038ads
{margin-bottom:10px;}#yiv3255654038 #yiv3255654038ygrp-mkp .yiv3255654038ad
{padding:0 0;}#yiv3255654038 #yiv3255654038ygrp-mkp ..yiv3255654038ad p
{margin:0;}#yiv3255654038 #yiv3255654038ygrp-mkp .yiv3255654038ad a
{color:#0000ff;text-decoration:none;}#yiv3255654038 #yiv3255654038ygrp-sponsor
#yiv3255654038ygrp-lc {font-family:Arial;}#yiv3255654038
#yiv3255654038ygrp-sponsor #yiv3255654038ygrp-lc #yiv3255654038hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3255654038
#yiv3255654038ygrp-sponsor #yiv3255654038ygrp-lc .yiv3255654038ad
{margin-bottom:10px;padding:0 0;}#yiv3255654038 #yiv3255654038actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3255654038
#yiv3255654038activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3255654038
#yiv3255654038activity span {font-weight:700;}#yiv3255654038
#yiv3255654038activity span:first-child
{text-transform:uppercase;}#yiv3255654038 #yiv3255654038activity span a
{color:#5085b6;text-decoration:none;}#yiv3255654038 #yiv3255654038activity span
span {color:#ff7900;}#yiv3255654038 #yiv3255654038activity span
.yiv3255654038underline {text-decoration:underline;}#yiv3255654038
.yiv3255654038attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3255654038 .yiv3255654038attach div a
{text-decoration:none;}#yiv3255654038 .yiv3255654038attach img
{border:none;padding-right:5px;}#yiv3255654038 .yiv3255654038attach label
{display:block;margin-bottom:5px;}#yiv3255654038 .yiv3255654038attach label a
{text-decoration:none;}#yiv3255654038 blockquote {margin:0 0 0
4px;}#yiv3255654038 .yiv3255654038bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3255654038
.yiv3255654038bold a {text-decoration:none;}#yiv3255654038 dd.yiv3255654038last
p a {font-family:Verdana;font-weight:700;}#yiv3255654038 dd.yiv3255654038last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3255654038
dd.yiv3255654038last p span.yiv3255654038yshortcuts
{margin-right:0;}#yiv3255654038 div.yiv3255654038attach-table div div a
{text-decoration:none;}#yiv3255654038 div.yiv3255654038attach-table
{width:400px;}#yiv3255654038 div.yiv3255654038file-title a, #yiv3255654038
div.yiv3255654038file-title a:active, #yiv3255654038
div.yiv3255654038file-title a:hover, #yiv3255654038 div.yiv3255654038file-title
a:visited {text-decoration:none;}#yiv3255654038 div.yiv3255654038photo-title a,
#yiv3255654038 div.yiv3255654038photo-title a:active, #yiv3255654038
div.yiv3255654038photo-title a:hover, #yiv3255654038
div.yiv3255654038photo-title a:visited {text-decoration:none;}#yiv3255654038
div#yiv3255654038ygrp-mlmsg #yiv3255654038ygrp-msg p a
span.yiv3255654038yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3255654038
.yiv3255654038green {color:#628c2a;}#yiv3255654038 .yiv3255654038MsoNormal
{margin:0 0 0 0;}#yiv3255654038 o {font-size:0;}#yiv3255654038
#yiv3255654038photos div {float:left;width:72px;}#yiv3255654038
#yiv3255654038photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3255654038
#yiv3255654038photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3255654038
#yiv3255654038reco-category {font-size:77%;}#yiv3255654038
#yiv3255654038reco-desc {font-size:77%;}#yiv3255654038 .yiv3255654038replbq
{margin:4px;}#yiv3255654038 #yiv3255654038ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3255654038 #yiv3255654038ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3255654038
#yiv3255654038ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3255654038
#yiv3255654038ygrp-mlmsg select, #yiv3255654038 input, #yiv3255654038 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3255654038
#yiv3255654038ygrp-mlmsg pre, #yiv3255654038 code {font:115%
monospace;}#yiv3255654038 #yiv3255654038ygrp-mlmsg *
{line-height:1.22em;}#yiv3255654038 #yiv3255654038ygrp-mlmsg #yiv3255654038logo
{padding-bottom:10px;}#yiv3255654038 #yiv3255654038ygrp-msg p a
{font-family:Verdana;}#yiv3255654038 #yiv3255654038ygrp-msg
p#yiv3255654038attach-count span {color:#1E66AE;font-weight:700;}#yiv3255654038
#yiv3255654038ygrp-reco #yiv3255654038reco-head
{color:#ff7900;font-weight:700;}#yiv3255654038 #yiv3255654038ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3255654038 #yiv3255654038ygrp-sponsor
#yiv3255654038ov li a {font-size:130%;text-decoration:none;}#yiv3255654038
#yiv3255654038ygrp-sponsor #yiv3255654038ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3255654038
#yiv3255654038ygrp-sponsor #yiv3255654038ov ul {margin:0;padding:0 0 0
8px;}#yiv3255654038 #yiv3255654038ygrp-text
{font-family:Georgia;}#yiv3255654038 #yiv3255654038ygrp-text p {margin:0 0 1em
0;}#yiv3255654038 #yiv3255654038ygrp-text tt {font-size:120%;}#yiv3255654038
#yiv3255654038ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3255654038
