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

 

Bisa pakai sumif, sumproduct maupun pivot table.
Yang tidak bisa adalah memberi contohnya, karena di email yang aku terima
tidak ada file excelnya.

________________________________________
From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf
Of sofyan.jusuf@trakindo.co.id
Sent: Thursday, February 18, 2010 5:45 PM
To: XL-mania@yahoogroups.com
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.
===========================================================================

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4878 (20100218) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__._,_.___

Reply to sender | Reply to group

Messages in this topic (14)

Recent Activity:

• New Members 118

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

.

__,_._,___