ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

·í¤ë¥÷Àx¦s®æ­pºâ

·í¤ë¥÷Àx¦s®æ­pºâ

·í¤ë¤é´Á

¹Ï¤ù1.gif
2013-11-12 11:30

§Ú¦bG1³B¤ñ¹ï·í¤ë§¹¦¨¥ó¼Æ«á,=IF(COUNTA(N5:N26),COUNTIF(K5:K26,">="&$Q$1),)
µo²{·í§Ú¶W¹L¤F11¤ë¥÷«á,¥L¨Ì­pºâ¬°·í¤ë¥÷,³o³¡¤À§Ú¸Ó¦p¦ó§ó§ï§Úªº¤½¦¡©O?
§Ú²{¦bªº°µªk´N11/1°¨¤W´N§ó¸ÓÀɦW±N¸ê®Æ¹ïÀ³§ó§ï¦¨11¤ë¥÷,³o¼Ë«á­±¦A¿é¤J¶i¨Óªº¸ê®Æ´N·|¤ñ¹ï¦¨11¤ë¤F
Jodie

¦^´_ 1# chwjj5059
¥i¥H¤W¶ÇÀɮסH

TOP

>§Ú¦bG1³B¤ñ¹ï·í¤ë§¹¦¨¥ó¼Æ«á,=IF(COUNTA(N5:N26),COUNTIF(K5:K26,">="&$Q$1),)
>µo²{·í§Ú¶W¹L¤F11¤ë¥÷«á,¥L¨Ì­pºâ¬°·í¤ë¥÷,³o³¡¤À§Ú¸Ó¦p¦ó§ó§ï§Úªº¤½¦¡©O?

¥Ñ¹Ï¤ùµLªkª¾¹D $Q$1 ¤å¦r©Î¼Æ¦r©Î¤é´Á
°²¦p K5:K26 ¬O¤é´Á«¬ºA¡A  $Q$1«Øij¿é¤J =DATE(YEAR(NOW()),MONTH(NOW()),1) ®æ¦¡¤Æ¬° "yyyy¦~mm¤ë"
¨ì11¤ë¥÷¦Û°Ê²Î­p 2013/11/1¥H«áªº¤é´Á
¨ì12¤ë¥÷¦Û°Ê²Î­p 2013/12/1¥H«áªº¤é´Á
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD