Bahasa Indonesia saja... 1. bisa pakai SUMPRODUCT 2. bisa pakai SUM((..)*(..)) -> array formula 3. bisa pakai SUM(IF(..)) -> array formula
-zam- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Syaiful Sent: Thursday, August 05, 2010 13:20 To: [email protected] 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 .....!!
