Thank you Mr. Kid !!!
----- Original Message ----- From: Kid Mr. To: [email protected] Sent: Saturday, October 15, 2011 3:07 PM Subject: Re: [belajar-excel] Cara menghitung per group Yang Total per branch : (pada branch A) =COUNTIF($A$3:$A$30,D3) Copy kebawah Yang per class per branch : (pada branch A class 1) =SUMPRODUCT(($A$3:$A$30=$D3)*($B$3:$B$30=F$2)) Copy ke bawah dan kanan Kid. 2011/10/15 Muhammad Assegaf <[email protected]> To all my friends,.. Saya lagi mau coba menghitung pergroup nih,.. tapi belum dapet caranya,.. ada yang bisa bantu gak nih ? bisa liat di attachment,.. makasih yah
