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/