Re: ]] XL-mania [[ Menghitung nilai dari range waktu tertentu

 

Pakai kolom bantu Bulan dan Tahun kemudian dibuat Pivot Tabel seperti contoh terlampir.

 

Salam,

Hendrik Karnadi

---

From: "sofyan.jusuf@trakindo.co.id" <sofyan.jusuf@trakindo.co.id>
To: XL-mania@yahoogroups.com
Sent: Thursday, February 18, 2010 17:45:22
Subject: ]] XL-mania [[ Menghitung nilai dari range waktu tertentu

 

Dear pakar excel.

Bagaimana cara menggunakan fungsi SUMIF, jika ingin menghitung value data dari range waktu tertentu.
misalnya menghitung total nilai khusu bulan january saja. atau khusus tahun 2010 saja. sementara data kita terdiri dari
data total tahun 2010,2011,2012. Tanpa harus memisahkan data tersebut per tahun nya?

jika tidak mengunakan fungsi SUMif.. adakah cara yang lain???

Thanks A lot!
rgds
sfn

============ ========= ========= ========= ========= ========= ========= ========= This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. The Trakindo Group of Companies do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by the Tiara Marga Trakindo Group of Companies and this email is not an offer, solicitation, recommendation or agreement of any kind. ============ ========= ========= ========= ========= ========= ========= =========

---

New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!

__._,_.___

Reply to sender | Reply to group

Messages in this topic (16)

Recent Activity:

• New Members 124

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| malu bertanya kerja manual... kebanyakan nanya (malas lihat post  |
| lama, nanya itu2 aja, males liat help) capeee deh... :( :( :(     | 
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___