Dear Pak Zam Dalam hal ini tidak ada kriterianya pak , hanya saja nilai yang dihitung adalah sell yang pertama jika ada nilai didepannya sd 4 colum tidak termasuk nilainya , baru dihitung sell yang berikutnya ( susah juga sih pak menjelaskannya )
Thanks ----- Original Message ----- From: Ahmad Zamroni To: [email protected] Sent: Monday, June 16, 2008 10:38 AM Subject: RE: [belajar-excel] Counta mestinya ada kriteria yang menyebabkan beberapa cell berwarna kuning. kalau memang ada, mungkin bisa dituliskan Pak apa kriterianya dari situ akan dengan mudah dibuatkan formulanya tapi kalau kriteria yang dimaksud sudah ada, yaitu cell warna kuning, mau tidak mau harus pake macro -zam- http://wongmbatu.blogspot.com/ ------------------------------------------------------------------------------ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Abdul Sent: Monday, June 16, 2008 8:59 AM To: [email protected] Subject: [belajar-excel] Counta Dear Mbak siti & All Formula mana ya, yang mesti dipakai untuk menghitung data seperti terlampir, untuk solusinya kalau bisa jangan pakai Macro. Thanks Salam Abdul ------------------------------------------------------------------------------ Internal Virus Database is out-of-date. Checked by AVG. Version: 7.5.520 / Virus Database: 0.0.0/0 - Release Date: <unknown> 12:00 AM DISCLAIMER<br /> ---------------<br /> "This email and any files transmitted with it are private and confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. If you are not an intended recipient, you are hereby notified that any disclosure, copying, or distribution of this email, and/or taking any action based on its content, is strictly prohibited, and you should: (i) immediately delete this email and its attachments from your system, and (ii) inform the sender by reply email that you are not an intended recipient. Please note that any views or opinions presented in this email are solely those of the author/sender and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group does not accept (i) any liability for its employee's communications that are against ANJ Agri's core values and/or outside the scope of employment and (ii) any damage caused by any virus transmitted by this email. Details can be found at: http://www.anjagri.com/disclaimer.htm";
