Rabu, 31 Agustus 2016

[belajar-excel] Digest Number 3953

4 Messages

Digest #3953

Messages

Tue Aug 30, 2016 3:31 am (PDT) . Posted by:

"Fendik Anton Wijaya"

Dear Para suhu & master,

Terima kasih sebelumnya om Odong Nando...sangat mencerahkan ilmu saya...

Setelah saya coba rumusnya om Odong Nando saya baru sadar ternyata ada parameter yag ketinggalan...jadi parameter semakin kompleks...
Setelah saya coba formulanya ada yg miss karena parameter inst ke- nya ketinggalan g saya masukkan jadi yg terbaca banyak sekali...

Berikut saya lampirkan contoh excel yg seharusnya...

Mohon bantuan para master sekalian...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Tuesday, August 30, 2016 3:21 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

=SUMPRODUCT(--(D5:D17>=EDATE(TODAY();-6))*--(E5:E17<=7))

EDATE bisa di ganti dengan EOMONTH, bila menginginkan month nya dibatsi dengan nilai bulannya saja, tidak termasuk tanggal, sebab formula di atas akan menghitung 5 bulan yang anda maksud namun di sesuaikan dengan tanggalnya.

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 11:29
Judul: Re: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear Om Odong Nando,

Sudah saya coba om tapi hasilnya 0...sudah saya jelaskan di kolom excel terlampir...

Terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Tuesday, August 30, 2016 12:01 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

coba formula,

=COUNTIF(D5:D17;">="&TODAY()-7)

bila kompi setempat berigional english ganti titik koma ";" dengan koma ","

bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

Terima kasih banyak Om Odong Nando atas responnya...

Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...
Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan...

Mohon maaf om klo penjelasannya kurang jelas...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Monday, August 29, 2016 6:13 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli.
Atas bantuannya saya ucapkan Terima Kasih Banyak.
Semoga Amal dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...
Sekali lagi terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

-------------------

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

Please consider the environment before printing this email.

Tue Aug 30, 2016 7:18 pm (PDT) . Posted by:

"odong nando"

setelah "...*--(E5:E17<=7)..." bisa anda tambahkan lagi kok, bahkan 10 kriteria bisa...
"...*--(E5:E17<=7)*--(D5:D17..._kasih operator yang anda mau, "< > ="_isi nilai yang sesuai) ..."
br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 16:12
Judul: Re: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

  Dear Para suhu & master, Terima kasih sebelumnya om Odong Nando...sangat mencerahkan ilmu saya... Setelah saya coba rumusnya om Odong Nando saya baru sadar ternyata ada parameter yag ketinggalan...jadi parameter semakin kompleks...Setelah saya coba formulanya ada yg miss karena parameter inst ke- nya ketinggalan g saya masukkan jadi yg terbaca banyak sekali... Berikut saya lampirkan contoh excel yg seharusnya...
Mohon bantuan para master sekalian... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Tuesday, August 30, 2016 3:21 PMTo: belajar-excel@yahoogroups.com Subject: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat   =SUMPRODUCT(--(D5:D17>=EDATE(TODAY();-6))*--(E5:E17<=7))
EDATE bisa di ganti dengan EOMONTH, bila menginginkan month nya dibatsi dengan nilai bulannya saja, tidak termasuk tanggal, sebab formula di atas akan menghitung 5 bulan yang anda maksud namun di sesuaikan dengan tanggalnya. br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 11:29
Judul: Re: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]
   Dear Om Odong Nando, Sudah saya coba om tapi hasilnya 0...sudah saya jelaskan di kolom excel terlampir... Terima kasih banyak atas bantuannya... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Tuesday, August 30, 2016 12:01 PMTo: belajar-excel@yahoogroups.com Subject: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat   coba formula,
=COUNTIF(D5:D17;">="&TODAY()-7)
 bila kompi setempat berigional english ganti titik koma ";" dengan koma ","
bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat
   Terima kasih banyak Om Odong Nando atas responnya... Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan... Mohon maaf om klo penjelasannya kurang jelas... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Monday, August 29, 2016 6:13 PMTo: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat   yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?
 br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]
   Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli. Atas bantuannya saya ucapkan Terima Kasih Banyak.Semoga Amal  dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...Sekali lagi terima kasih banyak atas bantuannya... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span>Towards a Sustainable Future - Please consider the environment before printing this email.
#yiv4509667372 #yiv4509667372 -- #yiv4509667372ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4509667372 #yiv4509667372ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4509667372 #yiv4509667372ygrp-mkp #yiv4509667372hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4509667372 #yiv4509667372ygrp-mkp #yiv4509667372ads {margin-bottom:10px;}#yiv4509667372 #yiv4509667372ygrp-mkp .yiv4509667372ad {padding:0 0;}#yiv4509667372 #yiv4509667372ygrp-mkp .yiv4509667372ad p {margin:0;}#yiv4509667372 #yiv4509667372ygrp-mkp .yiv4509667372ad a {color:#0000ff;text-decoration:none;}#yiv4509667372 #yiv4509667372ygrp-sponsor #yiv4509667372ygrp-lc {font-family:Arial;}#yiv4509667372 #yiv4509667372ygrp-sponsor #yiv4509667372ygrp-lc #yiv4509667372hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4509667372 #yiv4509667372ygrp-sponsor #yiv4509667372ygrp-lc .yiv4509667372ad {margin-bottom:10px;padding:0 0;}#yiv4509667372 #yiv4509667372actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4509667372 #yiv4509667372activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4509667372 #yiv4509667372activity span {font-weight:700;}#yiv4509667372 #yiv4509667372activity span:first-child {text-transform:uppercase;}#yiv4509667372 #yiv4509667372activity span a {color:#5085b6;text-decoration:none;}#yiv4509667372 #yiv4509667372activity span span {color:#ff7900;}#yiv4509667372 #yiv4509667372activity span .yiv4509667372underline {text-decoration:underline;}#yiv4509667372 .yiv4509667372attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4509667372 .yiv4509667372attach div a {text-decoration:none;}#yiv4509667372 .yiv4509667372attach img {border:none;padding-right:5px;}#yiv4509667372 .yiv4509667372attach label {display:block;margin-bottom:5px;}#yiv4509667372 .yiv4509667372attach label a {text-decoration:none;}#yiv4509667372 blockquote {margin:0 0 0 4px;}#yiv4509667372 .yiv4509667372bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4509667372 .yiv4509667372bold a {text-decoration:none;}#yiv4509667372 dd.yiv4509667372last p a {font-family:Verdana;font-weight:700;}#yiv4509667372 dd.yiv4509667372last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4509667372 dd.yiv4509667372last p span.yiv4509667372yshortcuts {margin-right:0;}#yiv4509667372 div.yiv4509667372attach-table div div a {text-decoration:none;}#yiv4509667372 div.yiv4509667372attach-table {width:400px;}#yiv4509667372 div.yiv4509667372file-title a, #yiv4509667372 div.yiv4509667372file-title a:active, #yiv4509667372 div.yiv4509667372file-title a:hover, #yiv4509667372 div.yiv4509667372file-title a:visited {text-decoration:none;}#yiv4509667372 div.yiv4509667372photo-title a, #yiv4509667372 div.yiv4509667372photo-title a:active, #yiv4509667372 div.yiv4509667372photo-title a:hover, #yiv4509667372 div.yiv4509667372photo-title a:visited {text-decoration:none;}#yiv4509667372 div#yiv4509667372ygrp-mlmsg #yiv4509667372ygrp-msg p a span.yiv4509667372yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4509667372 .yiv4509667372green {color:#628c2a;}#yiv4509667372 .yiv4509667372MsoNormal {margin:0 0 0 0;}#yiv4509667372 o {font-size:0;}#yiv4509667372 #yiv4509667372photos div {float:left;width:72px;}#yiv4509667372 #yiv4509667372photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4509667372 #yiv4509667372photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4509667372 #yiv4509667372reco-category {font-size:77%;}#yiv4509667372 #yiv4509667372reco-desc {font-size:77%;}#yiv4509667372 .yiv4509667372replbq {margin:4px;}#yiv4509667372 #yiv4509667372ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4509667372 #yiv4509667372ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4509667372 #yiv4509667372ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4509667372 #yiv4509667372ygrp-mlmsg select, #yiv4509667372 input, #yiv4509667372 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4509667372 #yiv4509667372ygrp-mlmsg pre, #yiv4509667372 code {font:115% monospace;}#yiv4509667372 #yiv4509667372ygrp-mlmsg * {line-height:1.22em;}#yiv4509667372 #yiv4509667372ygrp-mlmsg #yiv4509667372logo {padding-bottom:10px;}#yiv4509667372 #yiv4509667372ygrp-msg p a {font-family:Verdana;}#yiv4509667372 #yiv4509667372ygrp-msg p#yiv4509667372attach-count span {color:#1E66AE;font-weight:700;}#yiv4509667372 #yiv4509667372ygrp-reco #yiv4509667372reco-head {color:#ff7900;font-weight:700;}#yiv4509667372 #yiv4509667372ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4509667372 #yiv4509667372ygrp-sponsor #yiv4509667372ov li a {font-size:130%;text-decoration:none;}#yiv4509667372 #yiv4509667372ygrp-sponsor #yiv4509667372ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4509667372 #yiv4509667372ygrp-sponsor #yiv4509667372ov ul {margin:0;padding:0 0 0 8px;}#yiv4509667372 #yiv4509667372ygrp-text {font-family:Georgia;}#yiv4509667372 #yiv4509667372ygrp-text p {margin:0 0 1em 0;}#yiv4509667372 #yiv4509667372ygrp-text tt {font-size:120%;}#yiv4509667372 #yiv4509667372ygrp-vital ul li:last-child {border-right:none !important;}#yiv4509667372

Wed Aug 31, 2016 1:54 am (PDT) . Posted by:

"Dede Sulaeman"

Dear Mr Fendik,

Mungkin file terlampir sesuai harapan...

Note : Perhitungan detailnya ada di sheet 2.

Masih belajar jadi pakai kolom bantu. Hehehe...

Salam,

DD

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 31 Agustus 2016 9:18
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

setelah "...*--(E5:E17<=7)..." bisa anda tambahkan lagi kok, bahkan 10 kriteria bisa...

"...*--(E5:E17<=7)*--(D5:D17..._kasih operator yang anda mau, "< > ="_isi nilai yang sesuai) ..."

br,

odong nando

_____

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 16:12
Judul: Re: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear Para suhu & master,

Terima kasih sebelumnya om Odong Nando...sangat mencerahkan ilmu saya...

Setelah saya coba rumusnya om Odong Nando saya baru sadar ternyata ada parameter yag ketinggalan...jadi parameter semakin kompleks...

Setelah saya coba formulanya ada yg miss karena parameter inst ke- nya ketinggalan g saya masukkan jadi yg terbaca banyak sekali...

Berikut saya lampirkan contoh excel yg seharusnya...

Mohon bantuan para master sekalian...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com

Sent: Tuesday, August 30, 2016 3:21 PM

To: belajar-excel@yahoogroups.com

Subject: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

=SUMPRODUCT(--(D5:D17>=EDATE(TODAY();-6))*--(E5:E17<=7))

EDATE bisa di ganti dengan EOMONTH, bila menginginkan month nya dibatsi dengan nilai bulannya saja, tidak termasuk tanggal, sebab formula di atas akan menghitung 5 bulan yang anda maksud namun di sesuaikan dengan tanggalnya.

br,

odong nando

_____

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 11:29
Judul: Re: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear Om Odong Nando,

Sudah saya coba om tapi hasilnya 0...sudah saya jelaskan di kolom excel terlampir...

Terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com

Sent: Tuesday, August 30, 2016 12:01 PM

To: belajar-excel@yahoogroups.com

Subject: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

coba formula,

=COUNTIF(D5:D17;">="&TODAY()-7)

bila kompi setempat berigional english ganti titik koma ";" dengan koma ","

bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu

br,

odong nando

_____

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

Terima kasih banyak Om Odong Nando atas responnya...

Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...

Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan...

Mohon maaf om klo penjelasannya kurang jelas...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com

Sent: Monday, August 29, 2016 6:13 PM

To: belajar-excel@yahoogroups.com

Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?

br,

odong nando

_____

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli.

Atas bantuannya saya ucapkan Terima Kasih Banyak.

Semoga Amal dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...

Sekali lagi terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

_____

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

_____

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

_____

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

_____

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

Wed Aug 31, 2016 1:54 am (PDT) . Posted by:

"Fendik Anton Wijaya"

Siap Om...nti saya coba formulanya...

Terima kasih banyak Om...nti klo belum solved nti saya tanya2 lagi...terima kasih banyak ya omm...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Wednesday, August 31, 2016 10:18 AM
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

setelah "...*--(E5:E17<=7)..." bisa anda tambahkan lagi kok, bahkan 10 kriteria bisa...

"...*--(E5:E17<=7)*--(D5:D17..._kasih operator yang anda mau, "< > ="_isi nilai yang sesuai) ..."

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 16:12
Judul: Re: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear Para suhu & master,

Terima kasih sebelumnya om Odong Nando...sangat mencerahkan ilmu saya...

Setelah saya coba rumusnya om Odong Nando saya baru sadar ternyata ada parameter yag ketinggalan...jadi parameter semakin kompleks...
Setelah saya coba formulanya ada yg miss karena parameter inst ke- nya ketinggalan g saya masukkan jadi yg terbaca banyak sekali...

Berikut saya lampirkan contoh excel yg seharusnya...

Mohon bantuan para master sekalian...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Tuesday, August 30, 2016 3:21 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

=SUMPRODUCT(--(D5:D17>=EDATE(TODAY();-6))*--(E5:E17<=7))

EDATE bisa di ganti dengan EOMONTH, bila menginginkan month nya dibatsi dengan nilai bulannya saja, tidak termasuk tanggal, sebab formula di atas akan menghitung 5 bulan yang anda maksud namun di sesuaikan dengan tanggalnya.

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 11:29
Judul: Re: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear Om Odong Nando,

Sudah saya coba om tapi hasilnya 0...sudah saya jelaskan di kolom excel terlampir...

Terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Tuesday, August 30, 2016 12:01 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

coba formula,

=COUNTIF(D5:D17;">="&TODAY()-7)

bila kompi setempat berigional english ganti titik koma ";" dengan koma ","

bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

Terima kasih banyak Om Odong Nando atas responnya...

Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...
Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan...

Mohon maaf om klo penjelasannya kurang jelas...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Monday, August 29, 2016 6:13 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli.
Atas bantuannya saya ucapkan Terima Kasih Banyak.
Semoga Amal dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...
Sekali lagi terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

-------------------

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

Please consider the environment before printing this email.

============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar