Dear mas Seto, Hanya saran saja, bagaimana kalo di tambahin di row tabelnya
untuk keterangan sbb:- jenis kelamin ( Laki - laki, perempuan)- Pendidikan
terakhir (SD, SMP, SMA, Diploma, S1,S2,S3)- Pekejaan (PNS, Swasta, Wiraswasta,
dll..)- Status Perkawinan (Sudah menikah, menikah, dll..)- Status dalam
keluarga (Kepala keluarga, istri, anak, dll..) Dengan di tambahnya row status
dalam keluarga akan mudah menghitung jumlah keluarga karena dengan asumsi satu
keluarga hanya memiliki satu kepala rumah tangga sehingga bisa di hitung dengan
formula excel berapa jumlah kepala keluarga dalam satu desa itu, juga bias di
hitung berapa laki-laki, perempuan, yg sudah menikah, yang belum menikah dll..
TerimaKasih.
Pada Selasa, 10 Maret 2015 13:04, "Seto Adi [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamu'alaikum wr.wb.
Yang terhormat para Master & para guru,
Terlampir adalah contoh data penduduk suatu kelurahan dengan 2 sheet data
Sheet pertama , pertanyaannya sama dengan pertanyaan terdahulu.Sheet kedua ,
membuat COUNTIF dengan kriteria panjang data (LEN)
Sebelumnya saya ucapkan terima kasih atas bentuannya.
WassalamSeto
#yiv0105676600 #yiv0105676600 -- #yiv0105676600ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0105676600
#yiv0105676600ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0105676600
#yiv0105676600ygrp-mkp #yiv0105676600hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0105676600 #yiv0105676600ygrp-mkp #yiv0105676600ads
{margin-bottom:10px;}#yiv0105676600 #yiv0105676600ygrp-mkp .yiv0105676600ad
{padding:0 0;}#yiv0105676600 #yiv0105676600ygrp-mkp .yiv0105676600ad p
{margin:0;}#yiv0105676600 #yiv0105676600ygrp-mkp .yiv0105676600ad a
{color:#0000ff;text-decoration:none;}#yiv0105676600 #yiv0105676600ygrp-sponsor
#yiv0105676600ygrp-lc {font-family:Arial;}#yiv0105676600
#yiv0105676600ygrp-sponsor #yiv0105676600ygrp-lc #yiv0105676600hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0105676600
#yiv0105676600ygrp-sponsor #yiv0105676600ygrp-lc .yiv0105676600ad
{margin-bottom:10px;padding:0 0;}#yiv0105676600 #yiv0105676600actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0105676600
#yiv0105676600activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0105676600
#yiv0105676600activity span {font-weight:700;}#yiv0105676600
#yiv0105676600activity span:first-child
{text-transform:uppercase;}#yiv0105676600 #yiv0105676600activity span a
{color:#5085b6;text-decoration:none;}#yiv0105676600 #yiv0105676600activity span
span {color:#ff7900;}#yiv0105676600 #yiv0105676600activity span
.yiv0105676600underline {text-decoration:underline;}#yiv0105676600
.yiv0105676600attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0105676600 .yiv0105676600attach div a
{text-decoration:none;}#yiv0105676600 .yiv0105676600attach img
{border:none;padding-right:5px;}#yiv0105676600 .yiv0105676600attach label
{display:block;margin-bottom:5px;}#yiv0105676600 .yiv0105676600attach label a
{text-decoration:none;}#yiv0105676600 blockquote {margin:0 0 0
4px;}#yiv0105676600 .yiv0105676600bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0105676600
.yiv0105676600bold a {text-decoration:none;}#yiv0105676600 dd.yiv0105676600last
p a {font-family:Verdana;font-weight:700;}#yiv0105676600 dd.yiv0105676600last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0105676600
dd.yiv0105676600last p span.yiv0105676600yshortcuts
{margin-right:0;}#yiv0105676600 div.yiv0105676600attach-table div div a
{text-decoration:none;}#yiv0105676600 div.yiv0105676600attach-table
{width:400px;}#yiv0105676600 div.yiv0105676600file-title a, #yiv0105676600
div.yiv0105676600file-title a:active, #yiv0105676600
div.yiv0105676600file-title a:hover, #yiv0105676600 div.yiv0105676600file-title
a:visited {text-decoration:none;}#yiv0105676600 div.yiv0105676600photo-title a,
#yiv0105676600 div.yiv0105676600photo-title a:active, #yiv0105676600
div.yiv0105676600photo-title a:hover, #yiv0105676600
div.yiv0105676600photo-title a:visited {text-decoration:none;}#yiv0105676600
div#yiv0105676600ygrp-mlmsg #yiv0105676600ygrp-msg p a
span.yiv0105676600yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0105676600
.yiv0105676600green {color:#628c2a;}#yiv0105676600 .yiv0105676600MsoNormal
{margin:0 0 0 0;}#yiv0105676600 o {font-size:0;}#yiv0105676600
#yiv0105676600photos div {float:left;width:72px;}#yiv0105676600
#yiv0105676600photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0105676600
#yiv0105676600photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0105676600
#yiv0105676600reco-category {font-size:77%;}#yiv0105676600
#yiv0105676600reco-desc {font-size:77%;}#yiv0105676600 .yiv0105676600replbq
{margin:4px;}#yiv0105676600 #yiv0105676600ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0105676600 #yiv0105676600ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0105676600
#yiv0105676600ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0105676600
#yiv0105676600ygrp-mlmsg select, #yiv0105676600 input, #yiv0105676600 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0105676600
#yiv0105676600ygrp-mlmsg pre, #yiv0105676600 code {font:115%
monospace;}#yiv0105676600 #yiv0105676600ygrp-mlmsg *
{line-height:1.22em;}#yiv0105676600 #yiv0105676600ygrp-mlmsg #yiv0105676600logo
{padding-bottom:10px;}#yiv0105676600 #yiv0105676600ygrp-msg p a
{font-family:Verdana;}#yiv0105676600 #yiv0105676600ygrp-msg
p#yiv0105676600attach-count span {color:#1E66AE;font-weight:700;}#yiv0105676600
#yiv0105676600ygrp-reco #yiv0105676600reco-head
{color:#ff7900;font-weight:700;}#yiv0105676600 #yiv0105676600ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0105676600 #yiv0105676600ygrp-sponsor
#yiv0105676600ov li a {font-size:130%;text-decoration:none;}#yiv0105676600
#yiv0105676600ygrp-sponsor #yiv0105676600ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0105676600
#yiv0105676600ygrp-sponsor #yiv0105676600ov ul {margin:0;padding:0 0 0
8px;}#yiv0105676600 #yiv0105676600ygrp-text
{font-family:Georgia;}#yiv0105676600 #yiv0105676600ygrp-text p {margin:0 0 1em
0;}#yiv0105676600 #yiv0105676600ygrp-text tt {font-size:120%;}#yiv0105676600
#yiv0105676600ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0105676600
