coba ini
untuk di F11
=IF(OR((F4&F10)="kam1";(F4&F10)="kam2";(F4&F10)="jum3");$C$10;"")
semoga sesuai harapan
__Winarno__
Pada Rabu, 15 April 2015 23:50, "'Tuti Hartati'
[email protected] [belajar-excel]"
<[email protected]> menulis:
Terimakasih mas winarno atas bantuannya tetapi kalau saya ingin
menambahkan rumusnya yaitu (jika hari kamis shift 1 dan shift 2 maka munculkan
jumlah peserta, jika shift 3 dan libur munculkan kosong), (jika hari jumat
shift 3 maka munculkan jumlah peserta jika shift 1,shift 2 dan libur munculkan
kosong), bagaimana ya rumus if nya karena untuk rumus if saya kurang
paham.Terimakasih sebelumnya. Tuti hartati From:
[email protected] [mailto:[email protected]]
Sent: Thursday, April 16, 2015 9:06 AM
To: [email protected]
Subject: Bls: [belajar-excel] Rumus untuk jumlah peserta coba iniuntuk kolom
F, selanjutnya copas =IF(ISNUMBER(F7);$C$7;"")
__Winarno__ Pada Rabu, 15 April 2015 18:46, "'Tuti Hartati'
[email protected] [belajar-excel]"
<[email protected]> menulis: Mohon dibantu, saya ingin membuat
jadwal belajar untuk karyawan, dimana sudah ada kolom shift, group dan jumlah
peserta.Dan saya ingin dibawah kolom shift dimunculkan juga jumlah pesertanya,
bagaimana ya rumusnya, mohon bantuannya. Terimakasih.Tuti Hartati
#yiv9738794599 #yiv9738794599 -- #yiv9738794599ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9738794599
#yiv9738794599ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9738794599
#yiv9738794599ygrp-mkp #yiv9738794599hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9738794599 #yiv9738794599ygrp-mkp #yiv9738794599ads
{margin-bottom:10px;}#yiv9738794599 #yiv9738794599ygrp-mkp .yiv9738794599ad
{padding:0 0;}#yiv9738794599 #yiv9738794599ygrp-mkp .yiv9738794599ad p
{margin:0;}#yiv9738794599 #yiv9738794599ygrp-mkp .yiv9738794599ad a
{color:#0000ff;text-decoration:none;}#yiv9738794599 #yiv9738794599ygrp-sponsor
#yiv9738794599ygrp-lc {font-family:Arial;}#yiv9738794599
#yiv9738794599ygrp-sponsor #yiv9738794599ygrp-lc #yiv9738794599hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9738794599
#yiv9738794599ygrp-sponsor #yiv9738794599ygrp-lc .yiv9738794599ad
{margin-bottom:10px;padding:0 0;}#yiv9738794599 #yiv9738794599actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9738794599
#yiv9738794599activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9738794599
#yiv9738794599activity span {font-weight:700;}#yiv9738794599
#yiv9738794599activity span:first-child
{text-transform:uppercase;}#yiv9738794599 #yiv9738794599activity span a
{color:#5085b6;text-decoration:none;}#yiv9738794599 #yiv9738794599activity span
span {color:#ff7900;}#yiv9738794599 #yiv9738794599activity span
.yiv9738794599underline {text-decoration:underline;}#yiv9738794599
.yiv9738794599attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9738794599 .yiv9738794599attach div a
{text-decoration:none;}#yiv9738794599 .yiv9738794599attach img
{border:none;padding-right:5px;}#yiv9738794599 .yiv9738794599attach label
{display:block;margin-bottom:5px;}#yiv9738794599 .yiv9738794599attach label a
{text-decoration:none;}#yiv9738794599 blockquote {margin:0 0 0
4px;}#yiv9738794599 .yiv9738794599bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9738794599
.yiv9738794599bold a {text-decoration:none;}#yiv9738794599 dd.yiv9738794599last
p a {font-family:Verdana;font-weight:700;}#yiv9738794599 dd.yiv9738794599last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9738794599
dd.yiv9738794599last p span.yiv9738794599yshortcuts
{margin-right:0;}#yiv9738794599 div.yiv9738794599attach-table div div a
{text-decoration:none;}#yiv9738794599 div.yiv9738794599attach-table
{width:400px;}#yiv9738794599 div.yiv9738794599file-title a, #yiv9738794599
div.yiv9738794599file-title a:active, #yiv9738794599
div.yiv9738794599file-title a:hover, #yiv9738794599 div.yiv9738794599file-title
a:visited {text-decoration:none;}#yiv9738794599 div.yiv9738794599photo-title a,
#yiv9738794599 div.yiv9738794599photo-title a:active, #yiv9738794599
div.yiv9738794599photo-title a:hover, #yiv9738794599
div.yiv9738794599photo-title a:visited {text-decoration:none;}#yiv9738794599
div#yiv9738794599ygrp-mlmsg #yiv9738794599ygrp-msg p a
span.yiv9738794599yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9738794599
.yiv9738794599green {color:#628c2a;}#yiv9738794599 .yiv9738794599MsoNormal
{margin:0 0 0 0;}#yiv9738794599 o {font-size:0;}#yiv9738794599
#yiv9738794599photos div {float:left;width:72px;}#yiv9738794599
#yiv9738794599photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9738794599
#yiv9738794599photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9738794599
#yiv9738794599reco-category {font-size:77%;}#yiv9738794599
#yiv9738794599reco-desc {font-size:77%;}#yiv9738794599 .yiv9738794599replbq
{margin:4px;}#yiv9738794599 #yiv9738794599ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9738794599 #yiv9738794599ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9738794599
#yiv9738794599ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9738794599
#yiv9738794599ygrp-mlmsg select, #yiv9738794599 input, #yiv9738794599 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9738794599
#yiv9738794599ygrp-mlmsg pre, #yiv9738794599 code {font:115%
monospace;}#yiv9738794599 #yiv9738794599ygrp-mlmsg *
{line-height:1.22em;}#yiv9738794599 #yiv9738794599ygrp-mlmsg #yiv9738794599logo
{padding-bottom:10px;}#yiv9738794599 #yiv9738794599ygrp-msg p a
{font-family:Verdana;}#yiv9738794599 #yiv9738794599ygrp-msg
p#yiv9738794599attach-count span {color:#1E66AE;font-weight:700;}#yiv9738794599
#yiv9738794599ygrp-reco #yiv9738794599reco-head
{color:#ff7900;font-weight:700;}#yiv9738794599 #yiv9738794599ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9738794599 #yiv9738794599ygrp-sponsor
#yiv9738794599ov li a {font-size:130%;text-decoration:none;}#yiv9738794599
#yiv9738794599ygrp-sponsor #yiv9738794599ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9738794599
#yiv9738794599ygrp-sponsor #yiv9738794599ov ul {margin:0;padding:0 0 0
8px;}#yiv9738794599 #yiv9738794599ygrp-text
{font-family:Georgia;}#yiv9738794599 #yiv9738794599ygrp-text p {margin:0 0 1em
0;}#yiv9738794599 #yiv9738794599ygrp-text tt {font-size:120%;}#yiv9738794599
#yiv9738794599ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9738794599
