[belajar-excel] Digest Number 4684

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4684

1a

Bls: [belajar-excel] Xcelsius Multiple Criteria [1 Attachment] by "odong nando"

1b

Re: Bls: [belajar-excel] Xcelsius Multiple Criteria by "Agus"

Messages

1a

Bls: [belajar-excel] Xcelsius Multiple Criteria [1 Attachment]

Tue Jan 8, 2019 1:59 am (PST) . Posted by:

"odong nando"

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: "idz.iman@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
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

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: Bls: [belajar-excel] Xcelsius Multiple Criteria

Tue Jan 8, 2019 3:52 pm (PST) . Posted by:

"Agus"

Assalamualaikum warahmatullah,
Dear Iman.

Jika Rumus Mas Odong benar berarti dapat menggunakan SUMPRODUCT:
=SUMPRODUCT(($B$9:$B$17=$C$4)*($C$9:$C$17=$C$5)*(D9:D17))
(bukan array formula)
Wassalam
NangAgus

On 1/8/2019 16:59, odong nando odongnando@yahoo.com [belajar-excel] wrote:
> 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:* "idz.iman@yahoo.com [belajar-excel]"
> <belajar-excel@yahoogroups.com>
> *Kepada:* belajar-excel@yahoogroups.com
> *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?
>
> salam
> Iman
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use