Dear Pak Samsudin,
Kalau menurut saya pada cell I4 pakai formula sum kemudian pada I5
menggunakan formula =I2/I3/I4 ( Ltr/Ton/Km )
Mohon maaf jika salah menafsirkan. tks
Salam,
uharyanto
On 12/05/2015 10:15 AM, Samsudin samsu...@bayan.com.sg [belajar-excel]
wrote:
Dear Pak Uharyanto,
Berikut file yang dimaksud, dimana pada file tersebut saya hanya
menampilkan data sebagian kecil sebagai contoh.
*Hormat saya,*
*Samsudin*
*From:*belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]
*Sent:* Tuesday, May 12, 2015 10:41 AM
*To:* belajar-excel@yahoogroups.com
*Subject:* Re: [belajar-excel] Formula Subtotal bersyarat
Kalau seandainya bapak kirim contohnya mungkin kami bisa bantu coba
coba cari jalan keluarnya.
Salam,
uharyanto
On 11/05/2015 3:14 PM, Samsudin samsu...@bayan.com.sg
<mailto:samsu...@bayan.com.sg> [belajar-excel] wrote:
Dear All Master Excel,
Ikut nimbrung sekalian ada kasus, saya harus menghitung Rasio
(Ltr/Ton/Km), kira-kiran saya harus menggunakan formula apa?
Karena kalau yang dihitung Cuma hanya ada satu hari bisa
menggunakan formula manual (Ltr/Ton/Km), tetapi jika harus
menghitung selama satu bulan, bagaimana?
*Hormat saya,*
*Samsudin*
*Mobile Phone; 0811 5427 227 / 0811 2810 068*
*From:*belajar-excel@yahoogroups.com
<mailto:belajar-excel@yahoogroups.com>
[mailto:belajar-excel@yahoogroups.com]
*Sent:* Monday, May 11, 2015 3:53 PM
*To:* belajar-excel@yahoogroups.com
<mailto:belajar-excel@yahoogroups.com>
*Subject:* Re: [belajar-excel] Formula Subtotal bersyarat
Mungkin bisa di coba SUMIF, SUMIFS, SUMPRODUCT
Tks
Salam,
uharyanto
On 11/05/2015 12:56 PM, halak hita halakhita1...@gmail.com
<mailto:halakhita1...@gmail.com> [belajar-excel] wrote:
Mohon bantuannya
Bagaimana membuat formula subtotal menghitung diatas angka nol
---------------------------------------------------------------------------------------------------
This message (including any attachments) contains confidential information
intended
for a specific individual and purpose, and is protected by law. If you are
not the
intended recipient, you should delete this message and hereby notified that
any
disclosure, copying, or distribution of this message (or any part thereof),
or the
taking of any action based on it, is strictly prohibited. No liability or
responsibility
is accepted if information or data is, for whatever reason corrupted or
does not reach
its intended recipient. No warranty is given that this email is free of
viruses. The
views expressed in this email are, unless otherwise stated, those of the
author and
not those of the Company or its management. The Company reserves the right
to monitor,
intercept and block emails addressed to its users or take any other action
in accordance
with its email use policy.
---------------------------------------------------------------------------------------------------
This message (including any attachments) contains confidential information
intended
for a specific individual and purpose, and is protected by law. If you are not
the
intended recipient, you should delete this message and hereby notified that any
disclosure, copying, or distribution of this message (or any part thereof), or
the
taking of any action based on it, is strictly prohibited. No liability or
responsibility
is accepted if information or data is, for whatever reason corrupted or does
not reach
its intended recipient. No warranty is given that this email is free of
viruses. The
views expressed in this email are, unless otherwise stated, those of the author
and
not those of the Company or its management. The Company reserves the right to
monitor,
intercept and block emails addressed to its users or take any other action in
accordance
with its email use policy.