Baru belajar juga nih..
Kalau datanya diletakkan di range C7 s.d C31, maka kira2 formulanya seperti ini
:
Yang SUCCESS : =SUM(IF(ISNUMBER(FIND("SUCCESS",C7:C31)),--LEFT(C7:C31,1),0))
plus CSE
Yang FAILED :
=SUM(IF(ISNUMBER(FIND("FAILED",C7:C31)),--MID(C7:C31,FIND("FAILED",C7:C31)-2,1),0))
plus CSE
Semoga file terlampir bisa menjawab.
Thanks & Regards,
~ Ahmad Adriansyah ~
________________________________ From: [email protected] on behalf of Rizalul Hak Sent: Fri 11/21/2008 11:17 To: [email protected] Subject: ]] XL-mania [[ Sukses dan gagal Aku lagi bingung nich, aku punya beberapa kumpulan registrasi yang sukses dan gagal tapi aku ga tau gimana caranya menghitung berapa registrasi yang sukses dan berapa yang gagal. SUCCESS REGISTRATION 1 SUCCESS 2 SUCCESS 2 SUCCESS, 1 FAILED 2 SUCCESS, 2 FAILED 6 SUCCESS, 4 FAILED 3 SUCCESS 2 SUCCESS 2 SUCCESS, 2 FAILED 1 SUCCESS, 3 FAILED 2 SUCCESS, 3 FAILED 2 SUCCESS 2 SUCCESS 2 SUCCESS, 1 FAILED 1 SUCCESS, 4 FAILED 3 SUCCESS, 1 FAILED 1 SUCCESS, 1 FAILED 2 SUCCESS, 2 FAILED 4 SUCCESS 2 SUCCESS 2 SUCCESS 1 SUCCESS, 1 FAILED 2 SUCCESS 4 SUCCESS 1 SUCCESS, 3 FAILED 1 FAILED Gimana rumus biar bisa ngejumlahin berapa registerasi yang sukses dan yang gagal??? Trims alot........................................
Book1.xls
Description: Book1.xls
