Didalam judul sumif banyak kriteria dan banyak sheet sy mencoba blajar dan memahami jadi ga bisa karena ddlam rumus ada tanda ^,maksud dari penggunaan in dalam rumus apa ya,soalnya sy jg srg mlihat para master jg kalo ngebahas pake tanda ^.
Berikut salah satu bagian cuplikan rumusnya: SUM((data2011!$A$3:$A$14>=($C$22-(--$C$21<4))*10^5+A37*100+4)*(data2011!$A$3:$A\ $14<=$C$22*10^5+A37*100+$C$21)*(-MID(data2011!$A$3:$A$14,5,3)=-A37)*(data2011!$C\ $3:$C$14+data2011!$F$3:$F$14+data2011!$I$3:$I$14+data2011!$K$3:$K$14)) Regards Tjahya hartono ============================================ Mod Note: karakter "^" adalah operator PANGKAT (power) 10 ^ 5 = 10 * 10 * 10 * 10 * 10 hasilnya 100000 jadi seperti 10 ditambah 5 NOL lagi ============================================ ------------------------------------ --------------------------------------------------------------------- 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/
