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.an...@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.an...@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.an...@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.an...@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.