hai, bisa coba :=+COUNTIF($a$1:$a$10;"<0") atau =+COUNTIF($a$1:$a$10;">0") thanks
Hormat saya, Felix ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of fitri chan Sent: 24 Maret 2009 13:23 To: [email protected] Subject: ]] XL-mania [[ menghitung banyak data yang bernilai negatif Dear All Suhu Excel, sy mau tanya sedikit, saya punya data nih sbb: -4 -2 -5 -9 6 7 9 Bgmn caranya menghitung banyaknya data yang bernilai negatif atau positif. Kalo dilihat dari data di atas sih. Yang bernilai negatif ada 4 & yang bernilai positif ada 3. Selama ini saya pake bantuan IF. > Jika sel<0 maka 2, Jika sel>0 maka 1 =IF(SEL<0;2;IF(SEL>0;1;0)) Jadi berdasarkan data di atas dengan menggunakan IF, dapatnya nih : 2 2 2 2 1 1 1 Trus untuk mendapatkan nilai negatif saya gunakan countif. =countif(range;2) Trus untuk dapet nilai positif =countif(range;1). Ada Gak cara yang lebih simple / bagaimana cara gabungin rumus tersebut. Atas bantuannya saya ucapkan terimakasih Andi Fitriani ________________________________ Buat sendiri desain eksklusif Messenger Pingbox Anda sekarang! <http://sg.rd.yahoo.com/id/messenger/pingbox/mailtagline/*http://id.mess enger.yahoo.com/pingbox/> Membuat tempat chat pribadi di blog Anda sekarang sangatlah mudah _____________________________________________________________________ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service. For further information visit http://www.messagelabs.com/stats.asp CONFIDENTIALITY NOTICE: This communication (which term shall include any attachments) contains information which is confidential and proprietary in nature and the copyright in which belongs to Zuellig Pharma Asia Pacific or a subsidiary of Zuellig Pharma Asia Pacific (hereafter referred to jointly and singularly as Zuellig Pharma) or a third party. This communication is intended solely for the individual to whom it is addressed. If you are not the intended recipient of this communication, you may not disseminate, distribute, copy or otherwise disclose or use the contents of this communication without the written authority of Zuellig Pharma. If you have received this communication in error, please delete and destroy all copies and kindly notify the sender by return email or telephone immediately. Thank you. Zuellig Pharma makes no representations or warranties in respect of the integrity of this communication, including but not limited to any warranty that this communication is free of errors, viruses or other malicious code, interception or interference. _______________________________________________________________________ This message has been checked for all known viruses by the MessageLabs Virus Scanning Service. For further information, visit http:\\www.messagelabs.com\stats.asp
