Re: ]] XL-mania [[ looping-sum

[abimono]

untuk yang kuning : =SUMPRODUCT((B2:B27)*(MOD(ROW(B2:B27),2)=0)) untuk yang putih : =SUMPRODUCT((B2:B27)*(MOD(ROW(B2:B27),2)<>0)) ----- Original Message ----- From: s.BDV.Andreas Sandy Palestyo To: XL-mania@yahoogroups.com Sent: Wednesday, May 03, 2006 10:24 AM Subject: ]] XL-mania [[ looping-sum Dear XL-Expert,     Mohon bantuannya untuk permasalahan saya (see attachment).. Mungkin masalah tersebut sudah pernah ada Terimakasih..     Regards, aNdre   +-:: XL-mania ::::::::::::::::::::----------------------------------+ |                                                                   | | 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  | | [EMAIL PROTECTED] atau kirimkan mereka file dari | | http://groups.yahoo.com/group/XL-mania/files/Promotion/           | +-------------------------------------------------------------------+ | Berikan testimoni Anda tentang XL-mania di :                      | | http://www.friendster.com/profiles/xlmania                        | +-------------------------------------------------------------------+ SPONSORED LINKS Business application software Microsoft excel training Microsoft excel tutorial Business application development Microsoft excel help Microsoft excel training course YAHOO! GROUPS LINKS  Visit your group "XL-mania" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Book1.xls
Description: MS-Excel spreadsheet