Terimakasih Pak Setyo atas masukan nya, problem saya bisa teratasi :) cuman yang bikin penasaran, kok harus pake tahan CTRL - SHIFT lalu ENTER ya pak ??
mohon pencerahan nya matur nuwun salam, Wiwien Setyo Suhartanto wrote: >Kolom A berisi Gaji >Kolom B berisi Status > >A2:A12 dan B2:12 disesuaikan dengan range data > >=SUM((A2:A12)*(B2:B12="L")) > >TAHAN CTRL-SHIFT lalu ENTER > >Formula akhir yang muncul adalah: > >{=SUM((A2:A12)*(B2:B12="L"))} > > > > > -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id 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/