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

 

Kalo datanya diletakkan pada A1:A4, formulasinya kira2 begini : “=COUNT(IF(--A1:A4>10;1))” trus akhiri dengan CSE....

Peace...

 

Sent from my BlueBerry® smartphone from Sinyal Kuat, Indosat....!!!

 

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Irwan Kurniawan
Sent: 17 Juli 2010 13:43
To: XL-mania@yahoogroups.com
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 (3)

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              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

---

Hobbies & Activities Zone: Find others who share your passions! Explore new interests.

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

.

__,_._,___