=SUMPRODUCT(--(VALUE(A1:A5)>10))
>semoga bermanfaat ________________________________ From: Irwan Kurniawan <[email protected]> To: "[email protected]" <[email protected]> Sent: Sat, July 17, 2010 1:42:56 PM 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.
