Kayak gini bukan pak ?
A B
1 200000 K
2 250000 K
3 225000 L
4 300000 K
5 400000 L
6 225000 L
7 275000 K
8 300000
9 245000
10 300000 K
11 325000 L
K 1325000
=SUMIF($B$1:$B$11,A13,$A$1:$A$11)
L 1175000 =SUMIF($B$1:$B$11,A14,$A$1:$A$11)
----- Original Message -----
From: "Setyo Suhartanto" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, September 07, 2006 9:37 PM
Subject: Re: [ITCENTER] Formula di Excel
> 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"))}
>
>
>
> On 9/8/06, Wiwien Marlistyanto <[EMAIL PROTECTED]> wrote:
> >
> > Rekans, minta dolong dong.....
> > saya punya permasalahan di excel nih, ceritanya gini :
> > ada 2 kolom, yaitu gaji dan status, contoh :
> >
> > Gaji status
> > 200000 K
> > 250000 K
> > 225000 L
> > 300000 K
> > 400000 L
> > 225000 L
> > 275000 K
> > 300000
> > 245000
> > 300000 K
> > 325000 L
> >
> > pertanyaan nya :
> > K menyatakan Kawin dan L menyatakan Lajang
> > bagaimana formula nya untuk menghitung jumlah gaji yang status nya L
> > saja ? dengan catatan kadang-kadang ada status yang masih belum di isi,
> > ini bisa dilihat dengan kosong nya kolom status.
> >
> > Mohon sekiranya bantuan dari rekan-rekan semuanya,
> >
> > Sebelum dan sesudahnya saya ucapkan terima kasih
> >
> > Salam,
> >
> > Wiwien
> >
> >
> >
>
>
> [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 ##
> $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$
>
> [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id
>
>
> 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 ##
$$ 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/
