Re: ]] XL-mania [[ Tanya Count untuk number yg bertipe data text

 

Dear Pak Irwan,

 

Kalau data tidak terlalu banyak (sampai ribuan row), bisa dicoba array formula ini:

=sum(if(--Range_data>10,1,0))

akhiri pengetikan dengan ctrl+shift+enter sehingga formula akan nampak diapit kurung kurawal {}

 

blessings,

tomz

 

----- Original Message -----

From: Irwan Kurniawan

To: XL-mania@yahoogroups.com

Sent: Saturday, July 17, 2010 3:42 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.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 111

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| yak.... tembus 15,000. member ke 15,000 angkat tangannnnn... mau  |
| momods kirimin coklat.... hehehe...                               |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___