Bls: [belajar-excel] Mencari rata-rata secara otomatis

2015-09-04 Terurut Topik Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel] 
terima kasih mr kid atas bantuannya, sudah sesuai dgn permasalahan jawabannya
 





 Pada Kamis, 3 September 2015 21:00, "'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]"  menulis:



     Hai Tjahya,


Coba formula :
=AVERAGEIFS($E4:INDEX(4:4,4+MAX(1,COUNTA($3:$3))),$E$3:INDEX($3:$3,4+MAX(1,COUNTA($3:$3))),B$19)


*** jika regional setting setempat adalah Indonesia, ganti karakter koma 
menjadi titik koma


Kid






2015-09-03 18:10 GMT+07:00 Tjahya Hartono tjahyahart...@yahoo.co.id 
[belajar-excel] :


     Dear Master excel,


 Nama murid Kode murid Paket Kelas R.W.B 1-Sep 2-Sep Phonic Writing Behaviour 
Phonic Writing Behaviour Reagan 2 2 BD IH 6 7 8 6 6 6 Claire 3 3 BD Holiday 7 7 
8 8 7 8 Clayton 7 7 BD Holiday 7 7 8 6 7 8 Lewis 7 7 BD IH 8 6 8 7 7 8 Austin 7 
7 BD IH 8 8 8 7 8 8 Max 9 9 Reguler HS 8 9 7 7 8 9 Breanna 10 10 Reguler IH 7 8 
9 6 8 9 Calvin 12 12 BD IH 6 6 8 8 8 8 Kimmy 13 13 BD IH 8 6 8 7 6 8 Allyson 17 
17 BD IH 8 9 9 8 6 8 Ethan 20 20 BD IH 8 6 8 8 9 8 Waka 22 22 BD IH 8 7 8 9 9 9 
Saya 23 23 BD IH 8 8 8 8 7 7 Kennie 27 27 BD IH 8 9 7 7 7 6
|  |
|  |  |  |
|  |


 Phonic Writing Behaviour Reagan 2 6 6.5 7 Claire 3 7.5 7 8 Clayton 7 6.5 7 8 
Lewis 7 7.5 6.5 8 Austin 7 7.5 8 8 Max 9 7.5 8.5 8 Breanna 10 6.5 8 9 Calvin 12 
7 7 8 Kimmy 13 7.5 6 8 Allyson 17 8 7.5 8.5 Ethan 20 8 7.5 8 Waka 22 8.5 8 8.5 
Saya 23 8 7.5 7.5 Kennie 27 7.5 8 6.5  Pertanyaannya:
Bagaimanamencari rata2 secara otomatis denganhasil seperti  contoh  bilamana 
tanggalnya terus bertambah, 


terima kasih untuk bantuannya





  #yiv2161517311 #yiv2161517311 -- #yiv2161517311ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2161517311 
#yiv2161517311ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2161517311 
#yiv2161517311ygrp-mkp #yiv2161517311hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2161517311 #yiv2161517311ygrp-mkp #yiv2161517311ads 
{margin-bottom:10px;}#yiv2161517311 #yiv2161517311ygrp-mkp .yiv2161517311ad 
{padding:0 0;}#yiv2161517311 #yiv2161517311ygrp-mkp .yiv2161517311ad p 
{margin:0;}#yiv2161517311 #yiv2161517311ygrp-mkp .yiv2161517311ad a 
{color:#ff;text-decoration:none;}#yiv2161517311 #yiv2161517311ygrp-sponsor 
#yiv2161517311ygrp-lc {font-family:Arial;}#yiv2161517311 
#yiv2161517311ygrp-sponsor #yiv2161517311ygrp-lc #yiv2161517311hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2161517311 
#yiv2161517311ygrp-sponsor #yiv2161517311ygrp-lc .yiv2161517311ad 
{margin-bottom:10px;padding:0 0;}#yiv2161517311 #yiv2161517311actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2161517311 
#yiv2161517311activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2161517311
 #yiv2161517311activity span {font-weight:700;}#yiv2161517311 
#yiv2161517311activity span:first-child 
{text-transform:uppercase;}#yiv2161517311 #yiv2161517311activity span a 
{color:#5085b6;text-decoration:none;}#yiv2161517311 #yiv2161517311activity span 
span {color:#ff7900;}#yiv2161517311 #yiv2161517311activity span 
.yiv2161517311underline {text-decoration:underline;}#yiv2161517311 
.yiv2161517311attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2161517311 .yiv2161517311attach div a 
{text-decoration:none;}#yiv2161517311 .yiv2161517311attach img 
{border:none;padding-right:5px;}#yiv2161517311 .yiv2161517311attach label 
{display:block;margin-bottom:5px;}#yiv2161517311 .yiv2161517311attach label a 
{text-decoration:none;}#yiv2161517311 blockquote {margin:0 0 0 
4px;}#yiv2161517311 .yiv2161517311bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2161517311 
.yiv2161517311bold a {text-decoration:none;}#yiv2161517311 dd.yiv2161517311last 
p a {font-family:Verdana;font-weight:700;}#yiv2161517311 dd.yiv2161517311last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2161517311 
dd.yiv2161517311last p span.yiv2161517311yshortcuts 
{margin-right:0;}#yiv2161517311 div.yiv2161517311attach-table div div a 
{text-decoration:none;}#yiv2161517311 div.yiv2161517311attach-table 
{width:400px;}#yiv2161517311 div.yiv2161517311file-title a, #yiv2161517311 
div.yiv2161517311file-title a:active, #yiv2161517311 
div.yiv2161517311file-title a:hover, #yiv2161517311 div.yiv2161517311file-title 
a:visited {text-decoration:none;}#yiv2161517311 div.yiv2161517311photo-title a, 
#yiv2161517311 div.yiv2161517311photo-title a:active, #yiv2161517311 
div.yiv2161517311photo-title a:hover, #yiv2161517311 
div.yiv2161517311photo-title a:visited {text-decoration:none;}#yiv2161517311 
div#yiv2161517311ygrp-mlmsg #yiv2161517311ygrp-msg p a 
span.yiv2161517311yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2161517311 
.yiv2161517311green {color:#628c2a;}#yiv2161517311 .yiv2161517311MsoNormal 
{margin:0 0 0 0;}#yiv2161517311 o {font-size:0;}#yiv2161517311

Re: [belajar-excel] Mencari rata-rata secara otomatis

2015-09-03 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] 
Hai Tjahya,

Coba formula :
=AVERAGEIFS($E4:INDEX(4:4,4+MAX(1,COUNTA($3:$3))),$E$3:INDEX($3:$3,4+MAX(1,COUNTA($3:$3))),B$19)

*** jika regional setting setempat adalah Indonesia, ganti karakter koma
menjadi titik koma

Kid



2015-09-03 18:10 GMT+07:00 Tjahya Hartono tjahyahart...@yahoo.co.id
[belajar-excel] :

>
>
> Dear Master excel,
>
> Nama murid Kode murid Paket Kelas R.W.B 1-Sep 2-Sep Phonic Writing
> Behaviour Phonic Writing Behaviour Reagan 2 2 BD IH 6 7 8 6 6 6 Claire 3 3
> BD Holiday 7 7 8 8 7 8 Clayton 7 7 BD Holiday 7 7 8 6 7 8 Lewis 7 7 BD IH 8
> 6 8 7 7 8 Austin 7 7 BD IH 8 8 8 7 8 8 Max 9 9 Reguler HS 8 9 7 7 8 9
> Breanna 10 10 Reguler IH 7 8 9 6 8 9 Calvin 12 12 BD IH 6 6 8 8 8 8 Kimmy
> 13 13 BD IH 8 6 8 7 6 8 Allyson 17 17 BD IH 8 9 9 8 6 8 Ethan 20 20 BD IH 8
> 6 8 8 9 8 Waka 22 22 BD IH 8 7 8 9 9 9 Saya 23 23 BD IH 8 8 8 8 7 7 Kennie
> 27 27 BD IH 8 9 7 7 7 6
> Phonic Writing Behaviour Reagan 2 6 6.5 7 Claire 3 7.5 7 8 Clayton 7 6.5 7
> 8 Lewis 7 7.5 6.5 8 Austin 7 7.5 8 8 Max 9 7.5 8.5 8 Breanna 10 6.5 8 9
> Calvin 12 7 7 8 Kimmy 13 7.5 6 8 Allyson 17 8 7.5 8.5 Ethan 20 8 7.5 8 Waka
> 22 8.5 8 8.5 Saya 23 8 7.5 7.5 Kennie 27 7.5 8 6.5
>
> Pertanyaannya:
>
> Bagaimana mencari rata2 secara otomatis dengan hasil seperti  contoh  bilamana
> tanggalnya terus bertambah,
>
> terima kasih untuk bantuannya
>
>
> 
>

[belajar-excel] Mencari rata-rata secara otomatis [1 Attachment]

2015-09-03 Terurut Topik Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel] 
Dear Master excel,


 Nama murid Kode murid Paket Kelas R.W.B 1-Sep 2-Sep Phonic Writing Behaviour 
Phonic Writing Behaviour Reagan 2 2 BD IH 6 7 8 6 6 6 Claire 3 3 BD Holiday 7 7 
8 8 7 8 Clayton 7 7 BD Holiday 7 7 8 6 7 8 Lewis 7 7 BD IH 8 6 8 7 7 8 Austin 7 
7 BD IH 8 8 8 7 8 8 Max 9 9 Reguler HS 8 9 7 7 8 9 Breanna 10 10 Reguler IH 7 8 
9 6 8 9  Calvin 12 12 BD IH 6 6 8 8 8 8 Kimmy 13 13 BD IH 8 6 8 7 6 8 Allyson 
17 17 BD IH 8 9 9 8 6 8 Ethan 20 20 BD IH 8 6 8 8 9 8 Waka 22 22 BD IH 8 7 8 9 
9 9 Saya 23 23 BD IH 8 8 8 8 7 7 Kennie 27 27 BD IH 8 9 7 7 7 6
|  |
|  |  |  |
|  |


 Phonic Writing Behaviour Reagan 2 6 6.5 7 Claire 3 7.5 7 8 Clayton 7 6.5 7 8 
Lewis 7 7.5 6.5 8 Austin 7 7.5 8 8 Max 9 7.5 8.5 8 Breanna 10 6.5 8 9 Calvin 12 
7 7 8 Kimmy 13 7.5 6 8  Allyson 17 8 7.5 8.5 Ethan 20 8 7.5 8 Waka 22 8.5 8 8.5 
Saya 23 8 7.5 7.5 Kennie 27 7.5 8 6.5  Pertanyaannya:
Bagaimanamencari rata2 secara otomatis denganhasil seperti  contoh  bilamana 
tanggalnya terus bertambah, 


terima kasih untuk bantuannya




Mencari rata2 setiap hari.xlsx
Description: MS-Excel 2007 spreadsheet