COUNTIF KURANG DARI

Untuk membayar hutang tulisan saya sebanyak 5 hari.. hari ini saya produksi satu tulisan lagi.. hitung-hitung nyicil.. harapannya tetep bisa memproduksi 365 posting dalam satu tahun.. resolusi!

Tadi, salah seorang rekan saya, sebut saja Prettong *bukan nama sebenarnya* menanyakan sesuatu tentang penggunaan Excel. Pertanyaannya sederhana: "Mas.. cara ngitung jumlah cell yang nilainya dibawah *sebut saja* 7 gimana?". "hemm.. menggelitik" benakku.

Tau sih bakalan pake COUNTIF. struktur COUNTIF ini sendiri biasanya =COUNTIF(range, criteria). Tapi biasanya langsung ngerefer ke jumlah sama dengan atau kondisi tertentu atau nilai cell tertentu,  gak pake lebih dari, kurang dari, kurang dari sama dengan, lebih dari sama dengan, atau embel-embel apapun itu..

Tanpa banyak bicara, langsung pencet F1. Ya..anda benar!!! fitur Help di Excel adalah gudang bantuan yang penuh dengan harta karun jawaban namun tersembunyi di hutan keyword search help. Beruntung saya tahu keyword yang tepat. That's right, COUNTIF. scroll dikit... eh ketemu.. Yay..!!! happy me :)

Rupanya klo kasus diatas kita cukup menggunakan "<7" sebagai kriterianya, cukup simpel bukan. jadi rumus yang digunakan adalah =COUNTIF($B$2:$F$7;"<7"). Tapi klo gak pernah pakai, ya mana bisa tau. Manfaatnya nolong temen, kadang-kadang ikut bantu nolong diri sendiri (untuk belajar) menambah pengetahuan.

Tambahan: mungkin teman-teman memperhatikan klo disana da cell yang referensinya hilang (C7) dan merupakan karakter "-"(C6). Jangan khawatir klo ini bakal ikut keitung karena dianggap nol, karena setelah saya coba dengan angka yang lebih besar, rupanya jumlah nilai yang terjaring sama yaitu 8.

Well that's all for today.. oiya, klo ada yang penasaran dengan kalimat yang dibawah tabel tersebut "Pake UDF Hitung Warna" itu apa maksudnya.. pantengin terus blog ini.. you'll get the answer tomorrow.. or the day after tomorrow, or maybe next week.. just wait :D

See you on my another post :) *jangan lupa komen klo bermanfaat ya, i really apreciate it :)

Hi there...!!! long time not see..

Hi there..!!!

Long time not see...

“CUT IT OUT...!!! We’ve already sick of read it...!”

Maybe that’s the expression that you guys would convey when reading my first two lines. Heel yeah! It’s no wonder, since this is my another-time-filler-post in my blog – typically me. It’s been two weeks since my last post – what an unproductive blogger, pity me. Sob.

“#pencetidung #buangingus *usap airmata #everythingsgonnabeokay *lambaikan saputangan”.

Ups… my bad. A lil’ bit of mixed and bunch of twisted over here. FYI, that’s strange line is a way how people (me included) express themselves in twitter (#DamnItsTrue said that it’s an abbreviation of Tell What I’m Thinking To Everyone Reading. Though I haven’t seen any strong evidence to confirm this theorem, I think this line of words is quite representative to best describe what twitter really is).

You’ll never get to the place you long for…

Unless you walk the path that guides you there… - Sevtigo, 15.04.2011

Well, as you guys know (or don’t know), I’m a man who is no good when dealing with words. Not words from Microsoft. Not that Ms. Words – in fact, I’m so damn good at it. #sombongkauanakmuda – here it goes again. Sometimes it’s cross my mind to write about Words. Yeah, maybe I’m going to write some tips and tricks using Microsoft Words. I’m going to write a lot! Yippee! Yippee! Yippee!. “But, what is the point if there’s no one read it?” I keep questioning myself. *mendadak #suram –here’s come the other, sigh. Let’s go back to the topic. Despite of my lacking in writing, I still have a strong will to become a legendary blogger –just like Naruto who deadly want to become a hokage.I really envy those peoples who enjoy to live their blogging life, namely Mr. Sedjatee, Bunda Mahes, Uda Riki, Aa’ Jon and another long list of blogger which is hard for me to name them all. Actually, I’m writing this post after doing a little walk to Uda Riki, Bunda Mahes, and Mr. Sedjatee’s Blog. It’s really a mind-blowing journey in a galaxy filled with star words you’ve never heard before. Exaggerating yet touch your heart mildly. It’s not a compliment. I’m feeling it, for real. And I, from the deep of my heart, -*lebay to the max– want to be able to write posts like them. Share and care would be my blog's vision. However, one post a week is a great start I think.

Sometimes, passion needs patience…

Cuz rush often make you crush... sevtigo, 15.04.2011