Dear Irwan, Coba : =SumProduct(-(-range_data<-10)) Regards. Kid.
On Sat, Jul 17, 2010 at 1:42 PM, Irwan Kurniawan <[email protected] > wrote: > > > 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. > >
