Sayang nya kurang jelas pertanyaannya, range nya itu mau diapain? Coba ini de
=If(and(a1>=8,a1<10),"masuk range","tidak masuk range) ================================================ Mods Note: Sepertinya Yang ditanyakan: Mencari BANYAKNYA (menghitung cacah) Data yg memenuhi kriteria. Sedangkan kriterianya = nilai2 yg masuk ke rentang yg disebutkan ================================================ -----Original Message----- From: "drs. afdal arief" <[email protected]> Date: Sun, 01 Apr 2012 03:33:38 To: <[email protected]> Subject: [belajar-excel] Mencari jumlah data dengan kriteria tertentu Halo para master excel, saya ditugasi mencari di sebuah daftar nilai jumlah siswa yang mendapat rantang nilai 8 s.d 9,99 dst . mohon pencerahan.. thanks ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [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/
