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/
