Re: ]] XL-mania [[ Mengelompokan ROW berdasarkan KRITERIA

 



	B	C	D	E	F
2
3	TOKO 8
4	TOTAL MO		-	-	-
5	TOTAL M1		249,183,850.00	261,768,806.00	105.10
6	TOTAL M2		495,222,100.00	563,047,610.00	113.70
7	TOTAL M3		118,969,500.00	149,788,734.00	125.90
8	TOTAL M4		443,528,350.00	524,108,386.00	118.20
9	TOTAL M5		96,110,700.00	113,185,040.00	117.80
10	TOTAL M6		91,918,500.00	99,952,731.00	108.70
11	TOTAL M7		220,791,900.00	242,904,388.00	110.00
12	TOTAL M8		-	-	-
13	TOTAL M9		-	-	-
14

 

rumusnya biasa, antara lain seperti ini (ditulis di D5, di sheet2)

=SUMPRODUCT((dbSheet!$A$2:$A$196=$B$3)*(dbSheet!$B$2:$B$196=$B4)*(dbSheet!C$2:C$196))

 

tapi sebelumnya kita harus punya sheet 'dbSheet'

dbDheet berisi tabel tiruan dari tabel yg ada di Sheet 1 tapi di'bikin bener' dikit...

Biar ndak perlu pusing� membuat tabel di dbSheet, kita pakai cara yg gampang saja

yaitu cara "pencet tombol"  (yg ada di sheet 1)

 

---

----- Original Message -----

From: Aldo Desatura b"

To: XL-mania

Sent: Wednesday, February 17, 2010 11:53 AM

Subject: ]] XL-mania [[ Mengelompokan ROW berdasarkan KRITERIA

dear,
mohon info gimana caranya mengelompokan Data dari contoh di attachment
menjadi

TOKO1
TOTAL MO
TOTAL M1
TOTAL M2
TOTAL M3
TOTAL M4
TOTAL M5
TOTAL M6
TOTAL M7
TOTAL M8
TOTAL M9

mohon info yah... rumusnya gimana sih
Aldo Desatura � & �

__._,_.___

Reply to sender | Reply to group

Messages in this topic (3)

Recent Activity:

• New Members 120

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

.

__,_._,___