Pakai Pivot saja pak..seperti attachment yg saya kirim...
----- Original Message -----
From: "al bino" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, May 06, 2005 2:39 PM
Subject: [ITCENTER] tanya rumus excel
> saya mohon pencerahan dr ITers ttg rumus excel > saya ingin menggunakan
> fungsi SUMIF tapi dgn 2 CRITERIA, gimana caranya?
>
> misalnya dari data sebagai berikut
> semester - sales - penjualan
> 1 - A - 10.000
> 1 - A - 35.000
> 1 - B - 15.000
> 1 - B - 50.000
> 2 - A - 20.000
> 2 - B - 15.000
> 2 - A - 25.000
> 2 - A - 10.000
>
> saya ingin mendapatkan summarynya sbb:
> semester - sales - penjualan
> 1 - A - 45.000
> 1 - B - 65.000
> 2 - A - 55.000
> 2 - B - 15.000
>
>
>
>
>
> --
> 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 ##
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
[Non-text portions of this message have been removed]
--
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 ##
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> 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/
