Dear Mbak Siti
Setelah data dibaris 1 saya perbaiki hasilnya menjadi 6, untuk itu saya koreksi
formulanya mudah2 tidak salah lagi
=SUMPRODUCT((A1:H1="A")*(A2:H2=0))
Thanks
----- Original Message -----
From: nm kid
To: belajar-excel@yahoogroups.com
Sent: Sunday, June 14, 2009 7:02 PM
Subject: Re: [belajar-excel] [Belajar Excel] Count kosong
return value CountIF() selalu integer dan argumen untuk parameter range tidak
akan pernah diproses sebagai array. CountIF() akan menghasilkan array
tergantung argumen untuk parameter kriteria artinya array hasil CountIF()
adalah sesuai array kriteria, bukan range.
Kid.
2009/6/14 siti <setiyowati.d...@gmail.com>
melengkapi saja:...
array formula: =SUM(IF((A1:H1="a")*(A2:H2="");1;0))
lihat workbook lampiran
note:
jika data di baris 1 diperbaiki (semula " a " di perbaiki menjadi "a"
rumus pak Hamid menghasilkan 6.
apa hanya di excel ku saja ya ??
On Wed, Jun 10, 2009 at 2:39 PM, Abdul Hamid <alu...@anjagri.com> wrote:
> 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
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";
