baca help nya ttg teori,manual dan aplikasi : keyword "Pivot table"
milis_aji wrote: > Makasih... > tapi masih ada ganjalan, gimana klo sy kepingin antara angka 2 dan 7 , > kl kita coba hitung manual ada > 11 angka. sy pakai countif(range,>=2 and <=7) tidak mau kerja...malah > dikasih nilai 0..mohon bantuannya.... > > thx > --- In [email protected] <mailto:mailplus%40yahoogroups.com>, > Anto <[EMAIL PROTECTED]> wrote: > > > > Monday, July 24, 2006, 7:23:16 AM, milis_aji wrote: > > > > > Misal sy punya satu kolom angka seperti : > 1,1,2,2,3,4,5,6,6,6,7,8,8 > > > bagaimana sy bikin rumus diexcel (diselnya atau macro) spy bs > > > menghitung jumlah angka antara 1 dan 4(dalam contoh diatas kita bs > > > menghitung manual ada 6 angka, yg di dpt dari angka 1 ada 2, 2 ada > 2, > > > 3 ada 1 dan 4 ada 1, shg jumlah angka antara 1 dan 4 adalah 6). > > > > Misalnya urutan angka diatas ada di kolom A1 s/d A13, maka formulanya > > =COUNTIF(A1:A13,"<5") > > -- > > Best regards, > > Anto > > > Send instant messages to your online friends http://au.messenger.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/WktRrD/lOaOAA/yQLSAA/BRUplB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mailplus/ <*> 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/
