Kalo datanya diletakkan pada A1:A4, formulasinya kira2 begini : "=COUNT(IF(--A1:A4>10;1))" trus akhiri dengan CSE....
Peace... Sent from my BlueBerryR smartphone from Sinyal Kuat, Indosat....!!! From: [email protected] [mailto:[email protected]] On Behalf Of Irwan Kurniawan Sent: 17 Juli 2010 13:43 To: [email protected] Subject: ]] XL-mania [[ Tanya Count untuk number yg bertipe data text Dear All, misalkan saya punya data sbb : 12 11 8 10 keempat data diatas bertipe text sedangkan saya mau mencari berapa jumlah data yang bernilai lebih dari 10. jika saya menggunakan COUNTIF hanya bisa untuk data dengan tipe number/bilangan. mohon solusinya dari rekan-rekan sekalian. _____ Unless specifically stated, any views or opinions expressed in this e-mail are those of the author only and does not constitute a formal view and/or opinion of PT. UNION SAMPOERNA TRIPUTRA PERSADA. All information and attachment in this e-mail is or may be confidential, legally privileged, and proprietary in nature or otherwise protected by law from disclosure and is intended solely for the use of the addressee(s). If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying or use of any part of this e-mail is strictly prohibited and unlawful, and you shall therefore notify the sender immediately and delete the e-mail from your computer.
