RE: ]] XL-mania [[ pertanyaan bilingual.... the answer will be bilingual?

 

Bahasa Indonesia saja...

1. bisa pakai SUMPRODUCT
2. bisa pakai SUM((..)*(..)) -> array formula
3. bisa pakai SUM(IF(..)) -> array formula

-zam-

-----Original Message-----
From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf
Of Syaiful
Sent: Thursday, August 05, 2010 13:20
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ pertanyaan bilingual.... the answer will be
bilingual?

Yth para ExcelMania....!!
Gimana yagh caranya klo kasusnya kayak..:
saya ingin membuat Format analisa umur piutang
misalnya di kolom A1 saya mau menjumlahkan berdasarkan: kriteria pertama
"kode pelanggan", kriteria kedua diambil dari kolom Umur dg syarat umurnya
"antara 1 sampai 30".......... di kolom B1 kriteria keduanya "antara 31
sampai 60"....... dan seterusnya.....
saya pakai SUMIFS tp saya bingung untuk nentukan kriteria kedua yaitu jumlah
jika umurnya sekian sampai sekian...???
Terima Kasih atas bantuannya.....!!

Designation of the ExcelMania ....!!
I want to make a format receivable aging analysis
for example in column A1 I want to add on: The first criteria for "customer
code", the second criterion is taken from the column Age dg age requirement
"between 1 to 30 ".......... in column B1 criteria for both "between 31 to
60 "....... and so on .....
I use my tp SUMIFS confused for a second criteria which determine the amount
if his age so until all ...???
Thank you for your help .....!!

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 73

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| yak.... tembus 15,000. member ke 15,000 angkat tangannnnn... mau  |
| momods kirimin coklat.... hehehe...                               |
| 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

.

__,_._,___