- ©«¤l
- 12
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-12-4
- ³Ì«áµn¿ý
- 2016-10-8
|
[µo°Ý] ½Ð±ÐÃö©ó¿z¿ï¤£«ü©wÄæ¦ìªº¤½¦¡¼gªk?
¦U¦ì¦n
¥»¤HEXCEL¤è±¬O·s¤â
·Q½Ð±Ð°ò¥»ªº°ÝÃD
¥H¤U¬°²{¦b¼gªº¤½¦¡
D1Ä檺¤½¦¡
=SUMIF(A1:A10,"2015¦~*",B1:B10)
E1Ä檺¤½¦¡
=SUMIF(A1:A10,"<>2015¦~*",B1:B10)
A11:B11Äæ¦ì¬OÁ`pÄæ¦ì
¥Ø«e¹J¨ì¤@Ó°ÝÃD¬O...
¦]¬°A1:A10ªºÄæ¦ì¬OnKEYIN¸ê®Æªº¦a¤è
A11:B11«h¬O¦Û°ÊÁ`pªº¦a¤è
D1¡BE1«h¬O¦Û°ÊÅã¥Ü¿z¿ïÁ`pªº¦a¤è
¦pªG·í§Úªº¸ê®Æ¤@Åܦh
¶W¹LA10¡BB10¥i¯à¦ÜA15¡BB15©Î100³£¦³¥i¯à
§Ú²Ä¤@Ó·Qªk¬O¥ý§â¤½¦¡¥ý½Æ»s¨ì100¥H¤W¦A¨ÓKEYIN¸ê®Æ
¦ý¬O·|¦Y¨ìÁ`p¨º¤@¦CªºÄæ¦ì
©Ò¥HE1ªºÄæ¦ì·|³s§âÁ`pªº¼Æ¾Ú¤]¥[¤J¶i¥h
½Ð°Ý³oÓ³¡¥÷§Ú¸Ó«ç»ò¼g·|¤ñ¸û¦n©O?
¦³¿ëªk³Ì«á¤@¦CªºÁ`pÄæ¦ìÀH¼W´î
¥¦·|¤@ª½¦b³Ì«á¤@ÓÄæ¦ì°µ¥H¤W¥[Á`ªº¤è¦¡¶Ü?
¬O¤£¬O§ÚÁ`pªºÄæ¦ì¤½¦¡n´«¼gªk?
¦]¬°§Ú¬O¥Î«öÁä¤Wªº¦Û°Ê¥[Á`°µªº..
ÁÂÁÂ |
|