[belajar-excel] Mohon bantuan jumlah data [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Mohon bantuan jumlah data [1 Attachment]

fajar ok
Dear para suhu, teman n brother,

Saya lagi belajar neh,

Mohon bantuan hitung jumlah data per umur, saya coba rumus tidak bisa
muncul (data saya ambil di cell yang juga pake rumus, apakah penyebanya itu
ya?)

Note : Cell yang diblok warna kuning

Regards,

Fajar

data tgl lahir.xls (42K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon bantuan jumlah data

Bagus-2
Dear pak Fajar;

Coba ganti rumus yang ada di colom "Usia"
=(TODAY()-C6)/365
menjadi
=ROUND((TODAY()-C6)/365,0)
lalu copy kebawah

Semoga sesuai harapan.
Wassalam
   Bagus


Pada tanggal Min, 19 Apr 2020 pukul 17.27 'P. Fajar Pratidina'
[hidden email] [belajar-excel] <[hidden email]>
menulis:

>
>
> Dear para suhu, teman n brother,
>
> Saya lagi belajar neh,
>
> Mohon bantuan hitung jumlah data per umur, saya coba rumus tidak bisa
> muncul (data saya ambil di cell yang juga pake rumus, apakah penyebanya itu
> ya?)
>
> Note : Cell yang diblok warna kuning
>
> Regards,
>
> Fajar
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon bantuan jumlah data

fajar ok
ok terima kasih mas bagus

Pada tanggal Sen, 20 Apr 2020 pukul 08.18 Bagus [hidden email]
[belajar-excel] <[hidden email]> menulis:

>
>
> Dear pak Fajar;
>
> Coba ganti rumus yang ada di colom "Usia"
> =(TODAY()-C6)/365
> menjadi
> =ROUND((TODAY()-C6)/365,0)
> lalu copy kebawah
>
> Semoga sesuai harapan.
> Wassalam
>    Bagus
>
>
> Pada tanggal Min, 19 Apr 2020 pukul 17.27 'P. Fajar Pratidina'
> [hidden email] [belajar-excel] <[hidden email]>
> menulis:
>
>>
>>
>> Dear para suhu, teman n brother,
>>
>> Saya lagi belajar neh,
>>
>> Mohon bantuan hitung jumlah data per umur, saya coba rumus tidak bisa
>> muncul (data saya ambil di cell yang juga pake rumus, apakah penyebanya itu
>> ya?)
>>
>> Note : Cell yang diblok warna kuning
>>
>> Regards,
>>
>> Fajar
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon bantuan jumlah data

Sandy-2
In reply to this post by fajar ok
Penyebabnya:- Formula untuk menghitung usia dalam jumlah tahun harusnya dibulatkan (hasil aslinya masih berupa desimal; jadi bukan 36, tapi 35.8)- Formuls untuk menghitung jumlah data per-usia dibuat variabel usianya berdasarkan kolom H
Sandy

    On Sunday, April 19, 2020, 6:27:13 PM GMT+8, 'P. Fajar Pratidina' [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    

Dear para suhu, teman n brother,

Saya lagi belajar neh, 
Mohon bantuan hitung jumlah data per umur, saya coba rumus tidak bisa muncul (data saya ambil di cell yang juga pake rumus, apakah penyebanya itu ya?)
Note : Cell yang diblok warna kuning
Regards,

Fajar  #yiv6231215098 #yiv6231215098 -- #yiv6231215098ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6231215098 #yiv6231215098ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6231215098 #yiv6231215098ygrp-mkp #yiv6231215098hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6231215098 #yiv6231215098ygrp-mkp #yiv6231215098ads {margin-bottom:10px;}#yiv6231215098 #yiv6231215098ygrp-mkp .yiv6231215098ad {padding:0 0;}#yiv6231215098 #yiv6231215098ygrp-mkp .yiv6231215098ad p {margin:0;}#yiv6231215098 #yiv6231215098ygrp-mkp .yiv6231215098ad a {color:#0000ff;text-decoration:none;}#yiv6231215098 #yiv6231215098ygrp-sponsor #yiv6231215098ygrp-lc {font-family:Arial;}#yiv6231215098 #yiv6231215098ygrp-sponsor #yiv6231215098ygrp-lc #yiv6231215098hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6231215098 #yiv6231215098ygrp-sponsor #yiv6231215098ygrp-lc .yiv6231215098ad {margin-bottom:10px;padding:0 0;}#yiv6231215098 #yiv6231215098actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6231215098 #yiv6231215098activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6231215098 #yiv6231215098activity span {font-weight:700;}#yiv6231215098 #yiv6231215098activity span:first-child {text-transform:uppercase;}#yiv6231215098 #yiv6231215098activity span a {color:#5085b6;text-decoration:none;}#yiv6231215098 #yiv6231215098activity span span {color:#ff7900;}#yiv6231215098 #yiv6231215098activity span .yiv6231215098underline {text-decoration:underline;}#yiv6231215098 .yiv6231215098attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6231215098 .yiv6231215098attach div a {text-decoration:none;}#yiv6231215098 .yiv6231215098attach img {border:none;padding-right:5px;}#yiv6231215098 .yiv6231215098attach label {display:block;margin-bottom:5px;}#yiv6231215098 .yiv6231215098attach label a {text-decoration:none;}#yiv6231215098 blockquote {margin:0 0 0 4px;}#yiv6231215098 .yiv6231215098bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6231215098 .yiv6231215098bold a {text-decoration:none;}#yiv6231215098 dd.yiv6231215098last p a {font-family:Verdana;font-weight:700;}#yiv6231215098 dd.yiv6231215098last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6231215098 dd.yiv6231215098last p span.yiv6231215098yshortcuts {margin-right:0;}#yiv6231215098 div.yiv6231215098attach-table div div a {text-decoration:none;}#yiv6231215098 div.yiv6231215098attach-table {width:400px;}#yiv6231215098 div.yiv6231215098file-title a, #yiv6231215098 div.yiv6231215098file-title a:active, #yiv6231215098 div.yiv6231215098file-title a:hover, #yiv6231215098 div.yiv6231215098file-title a:visited {text-decoration:none;}#yiv6231215098 div.yiv6231215098photo-title a, #yiv6231215098 div.yiv6231215098photo-title a:active, #yiv6231215098 div.yiv6231215098photo-title a:hover, #yiv6231215098 div.yiv6231215098photo-title a:visited {text-decoration:none;}#yiv6231215098 div#yiv6231215098ygrp-mlmsg #yiv6231215098ygrp-msg p a span.yiv6231215098yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6231215098 .yiv6231215098green {color:#628c2a;}#yiv6231215098 .yiv6231215098MsoNormal {margin:0 0 0 0;}#yiv6231215098 o {font-size:0;}#yiv6231215098 #yiv6231215098photos div {float:left;width:72px;}#yiv6231215098 #yiv6231215098photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6231215098 #yiv6231215098photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6231215098 #yiv6231215098reco-category {font-size:77%;}#yiv6231215098 #yiv6231215098reco-desc {font-size:77%;}#yiv6231215098 .yiv6231215098replbq {margin:4px;}#yiv6231215098 #yiv6231215098ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6231215098 #yiv6231215098ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6231215098 #yiv6231215098ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6231215098 #yiv6231215098ygrp-mlmsg select, #yiv6231215098 input, #yiv6231215098 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6231215098 #yiv6231215098ygrp-mlmsg pre, #yiv6231215098 code {font:115% monospace;}#yiv6231215098 #yiv6231215098ygrp-mlmsg * {line-height:1.22em;}#yiv6231215098 #yiv6231215098ygrp-mlmsg #yiv6231215098logo {padding-bottom:10px;}#yiv6231215098 #yiv6231215098ygrp-msg p a {font-family:Verdana;}#yiv6231215098 #yiv6231215098ygrp-msg p#yiv6231215098attach-count span {color:#1E66AE;font-weight:700;}#yiv6231215098 #yiv6231215098ygrp-reco #yiv6231215098reco-head {color:#ff7900;font-weight:700;}#yiv6231215098 #yiv6231215098ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6231215098 #yiv6231215098ygrp-sponsor #yiv6231215098ov li a {font-size:130%;text-decoration:none;}#yiv6231215098 #yiv6231215098ygrp-sponsor #yiv6231215098ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6231215098 #yiv6231215098ygrp-sponsor #yiv6231215098ov ul {margin:0;padding:0 0 0 8px;}#yiv6231215098 #yiv6231215098ygrp-text {font-family:Georgia;}#yiv6231215098 #yiv6231215098ygrp-text p {margin:0 0 1em 0;}#yiv6231215098 #yiv6231215098ygrp-text tt {font-size:120%;}#yiv6231215098 #yiv6231215098ygrp-vital ul li:last-child {border-right:none !important;}#yiv6231215098  

data tgl lahir.xls (42K) Download Attachment