Sedikit koreksi untuk ini
{=SUM(--(($A$2:$A$165=A2)*(HOUR($B$2:$B$165)=HOUR(B2))))}
Ctrl + Shift + Enter
Rgds
From: [email protected] [mailto:[email protected]] On Behalf Of
De Premor
Sent: Thursday, July 04, 2013 7:17 PM
To: [email protected]
Subject: Re: ]] XL-mania [[ Menghitung jumlah data dengan kriteria
Coba pakai ginian =>
=SUM(--(($A$2:$A$165=A2)*(HOUR($B$2:$B$165)=HOUR(B2))))
atau
=SUMPRODUCT(($A$2:$A$165=A2)*(HOUR($B$2:$B$165)=HOUR(B2)))
Rgds,
[dp]
Pada 03/07/2013 13:53, margi menulis:
Dear para master excel
Mohon bantuan untuk dibuatkan rumusnya, soalnya selama ini saya hitungnya
manual sehingga membutuhkan waktu yang lama dan tidak efisien.
terima kasih atas bantuannya.
Regards,
MARGI
*** WORLEYPARSONS GROUP NOTICE ***
"This email is confidential. If you are not the intended recipient, you must
not disclose or use the information contained in it.
If you have received this email in error, please notify us immediately by
return email and delete the email and any attachments.
Any personal views or opinions expressed by the writer may not
necessarily reflect the views or opinions of any company in the WorleyParsons
Group of Companies."
