countif(rangenya, status yang diinginkan)
contoh: asumsi data sama kaya dibawah
untuk field cust a, ok:
COUNTIF(A2:B4,"ok")
field cust a, nok:
COUNTIF(A2:B4,"nok")
dst
[ dimas-n ]
----- Original Message -----
From: "Ferri AB" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 10, 2004 1:28 PM
Subject: [ITCENTER] COUNTIF
>
> dear all,
>
> ada yg tahu ngga rumus di excel untuk kasus sbb :
>
> Cust Status
> A OK
> A NOK
> A NOK
> B OK
> B NOK
> B OK
>
> bagaimana rumus untuk mengetahui masing2 customer dan statusnya?
> sehingga hasilnya sbb :
>
> Cust OK NOK
> A 1 2
> B 2 1
>
> terima kasih sebelumnya,
>
> ----------
> Ferri AB
> ----------
--
www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ##
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/
