Dear Pak Kids, terimakasih untuk masukannya, untuk excellnya saya persempit lagi.. Pertanyaannya: untuk menghitung user Aktif perbulan Mei 2017,Berapa User Kalibata, Aktivasi Sampai 31 Mei 2017, dan yang terminated mulai 01 Juni 2017 dst termasuk kolom kosong berarti masih Aktif.
Tambahan: untuk yang Terminated sampai 31 Mei berarti sudah tidak aktif.
semoga cukup untuk menjelaskan.
Terimakasih.
Bowo_Cilacap
On Friday, July 14, 2017 4:45 AM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Hai Bowo,
Kalau dilihat dari preview file lampirannya, kenapa tidak konsisten antara
Retail dengan Corporate.
Corporate Kalibata hasilnya 2, tetapi di data ada 3.
Lagi pula, kondisi yang bisa menghasilkan nilai-nilai hasil (mendekati) adalah
aktivasi sebelum juli 2017 (mungkin hari ini atau tanggal terakhir juli atau
tanggal tertentu juli) dan terminate date sebelum mei 2017 (sebelum tanggal 1
mei 2017) dengan data terminate date blank dianggap 0 atau tanggal 0 jan 1900
Bisa dijelaskan lebih detilkah ?
Regards,
Kid
2017-07-13 18:03 GMT+07:00 'ribowo .' ribow...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
dear excellers,
Mohon pencerahannya untuk penggunaan penghitungan data terlampir apakah hanya
bisa menggunakan countif atau formula yang lain,..
KALIBATA CITY hasilnya "3" dengan ketentuan berikut,
Retail_Kalibata City_Aktivasi (Juni-Juli 2017 take out)_Terminated (Sebelum Mei
2017 di takeout)
Sebelumnya saya ucapkan terimakasih.
Bowo_Cilacap
#yiv5218824463 -- #yiv5218824463ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5218824463
#yiv5218824463ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5218824463
#yiv5218824463ygrp-mkp #yiv5218824463hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5218824463 #yiv5218824463ygrp-mkp #yiv5218824463ads
{margin-bottom:10px;}#yiv5218824463 #yiv5218824463ygrp-mkp .yiv5218824463ad
{padding:0 0;}#yiv5218824463 #yiv5218824463ygrp-mkp .yiv5218824463ad p
{margin:0;}#yiv5218824463 #yiv5218824463ygrp-mkp .yiv5218824463ad a
{color:#0000ff;text-decoration:none;}#yiv5218824463 #yiv5218824463ygrp-sponsor
#yiv5218824463ygrp-lc {font-family:Arial;}#yiv5218824463
#yiv5218824463ygrp-sponsor #yiv5218824463ygrp-lc #yiv5218824463hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5218824463
#yiv5218824463ygrp-sponsor #yiv5218824463ygrp-lc .yiv5218824463ad
{margin-bottom:10px;padding:0 0;}#yiv5218824463 #yiv5218824463actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5218824463
#yiv5218824463activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5218824463
#yiv5218824463activity span {font-weight:700;}#yiv5218824463
#yiv5218824463activity span:first-child
{text-transform:uppercase;}#yiv5218824463 #yiv5218824463activity span a
{color:#5085b6;text-decoration:none;}#yiv5218824463 #yiv5218824463activity span
span {color:#ff7900;}#yiv5218824463 #yiv5218824463activity span
.yiv5218824463underline {text-decoration:underline;}#yiv5218824463
.yiv5218824463attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5218824463 .yiv5218824463attach div a
{text-decoration:none;}#yiv5218824463 .yiv5218824463attach img
{border:none;padding-right:5px;}#yiv5218824463 .yiv5218824463attach label
{display:block;margin-bottom:5px;}#yiv5218824463 .yiv5218824463attach label a
{text-decoration:none;}#yiv5218824463 blockquote {margin:0 0 0
4px;}#yiv5218824463 .yiv5218824463bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5218824463
.yiv5218824463bold a {text-decoration:none;}#yiv5218824463 dd.yiv5218824463last
p a {font-family:Verdana;font-weight:700;}#yiv5218824463 dd.yiv5218824463last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5218824463
dd.yiv5218824463last p span.yiv5218824463yshortcuts
{margin-right:0;}#yiv5218824463 div.yiv5218824463attach-table div div a
{text-decoration:none;}#yiv5218824463 div.yiv5218824463attach-table
{width:400px;}#yiv5218824463 div.yiv5218824463file-title a, #yiv5218824463
div.yiv5218824463file-title a:active, #yiv5218824463
div.yiv5218824463file-title a:hover, #yiv5218824463 div.yiv5218824463file-title
a:visited {text-decoration:none;}#yiv5218824463 div.yiv5218824463photo-title a,
#yiv5218824463 div.yiv5218824463photo-title a:active, #yiv5218824463
div.yiv5218824463photo-title a:hover, #yiv5218824463
div.yiv5218824463photo-title a:visited {text-decoration:none;}#yiv5218824463
div#yiv5218824463ygrp-mlmsg #yiv5218824463ygrp-msg p a
span.yiv5218824463yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5218824463
.yiv5218824463green {color:#628c2a;}#yiv5218824463 .yiv5218824463MsoNormal
{margin:0 0 0 0;}#yiv5218824463 o {font-size:0;}#yiv5218824463
#yiv5218824463photos div {float:left;width:72px;}#yiv5218824463
#yiv5218824463photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5218824463
#yiv5218824463photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5218824463
#yiv5218824463reco-category {font-size:77%;}#yiv5218824463
#yiv5218824463reco-desc {font-size:77%;}#yiv5218824463 .yiv5218824463replbq
{margin:4px;}#yiv5218824463 #yiv5218824463ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5218824463 #yiv5218824463ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5218824463
#yiv5218824463ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5218824463
#yiv5218824463ygrp-mlmsg select, #yiv5218824463 input, #yiv5218824463 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5218824463
#yiv5218824463ygrp-mlmsg pre, #yiv5218824463 code {font:115%
monospace;}#yiv5218824463 #yiv5218824463ygrp-mlmsg *
{line-height:1.22em;}#yiv5218824463 #yiv5218824463ygrp-mlmsg #yiv5218824463logo
{padding-bottom:10px;}#yiv5218824463 #yiv5218824463ygrp-msg p a
{font-family:Verdana;}#yiv5218824463 #yiv5218824463ygrp-msg
p#yiv5218824463attach-count span {color:#1E66AE;font-weight:700;}#yiv5218824463
#yiv5218824463ygrp-reco #yiv5218824463reco-head
{color:#ff7900;font-weight:700;}#yiv5218824463 #yiv5218824463ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5218824463 #yiv5218824463ygrp-sponsor
#yiv5218824463ov li a {font-size:130%;text-decoration:none;}#yiv5218824463
#yiv5218824463ygrp-sponsor #yiv5218824463ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5218824463
#yiv5218824463ygrp-sponsor #yiv5218824463ov ul {margin:0;padding:0 0 0
8px;}#yiv5218824463 #yiv5218824463ygrp-text
{font-family:Georgia;}#yiv5218824463 #yiv5218824463ygrp-text p {margin:0 0 1em
0;}#yiv5218824463 #yiv5218824463ygrp-text tt {font-size:120%;}#yiv5218824463
#yiv5218824463ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5218824463
tanya rumus, hitung countif.xlsx
Description: MS-Excel 2007 spreadsheet
