Diganti saja format cell nya menjadi number :) Smoga membantu :D simplifying the complexity, not complicating the simple things
-----Original Message----- From: Irwan Kurniawan <[email protected]> Sender: [email protected] Date: Sat, 17 Jul 2010 13:42:56 To: [email protected]<[email protected]> Reply-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.
