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: [email protected]
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/
