iya saya juga sependapat dengan mas danny apakah yang di maksud seperti dibawah
begini mas isi aja dulu angkanya sampai selesai nanti setelah selesai di paling bawah tinggal kasih =sum(C1:C1000) <=== di C1001 'ket : bila data yang diisi sampe seribu dan pengisian fieldnya bisa sampai berapa aja ________________________________ From: Danny <[EMAIL PROTECTED]> To: ITCENTER@yahoogroups.com Sent: Tuesday, December 9, 2008 11:41:52 AM Subject: Re: [ITCENTER] Tanya Macro Excel.. Mksudnya bgini bkn?, =SUM(C1:C2) 2008/12/3 johan handoko <emailnyajohan@ yahoo.com> > Dear all, > > Saya ingin membuat makro di excel, untuk kepentingan sbb : > > Kolom A1 dan A2 Berisi No.Cust 1234 (No Cust sama) > Kolom B1 dan B2 berisi Distribution Chanel Traditional dan Modern > Kolom C1 dan C2 berisi Nominal 15.000 dan 25.000 > > Bagaimana cara menjumlahkan 15.000 dan 25.000 ke dalam satu kolom > menggunakan Makro, karena data nya ribuan tidak mungkin saya jumlahkan satu > persatu. > > Thank in Advance. > > Johan > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/