Dear ITers,
Saya ada pertanyaan mengenai COUNTIF formula di Ms. Excel,,
Saya punya 1 field, katakan saja Status. Field ini mempunyai 10 record.
|Status|
1
2
3
4
4
4
0
1
1
3
dari field diatas, saya ingin tau total record yang isinya 4 saja. Berarti
formulanya adalah sbb:
=COUNTIF(A2:A11,"4")
Maka hasilnya = 3. Artinya, total record yang isinya 4 ada 3.
Pertanyaan saya adalah:
Apakah ada formula seperti itu didalam reportnya Ms. Access?
Thx & Regards,
Fauzan Febri
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
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/
