Pak Sepriansyah, Bisa menggunakan formula =SUMPRODUCT(COUNTIF(A1:H1,"A")*(A2:H2=0)), file terlampir
Thanks
----- Original Message -----
From: sepriansyah encep
To: belajar-excel@yahoogroups.com
Sent: Wednesday, June 10, 2009 1:49 PM
Subject: [belajar-excel] [Belajar Excel] Count kosong
Dear Friend
Mohon dibantu ya...
a b c d a b a d
12 5 2 4 4 23
Saya ingin mengetahui berap jumlah a yang kosong,
bagaimana ya...?
Terimakasih
------------------------------------------------------------------------------
Coba Yahoo! Messenger 9.0 baru Akhirnya datang juga!
DISCLAIMER
---------------
"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";
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";
Book1.xls
Description: MS-Excel spreadsheet
