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

[µo°Ý] ½Ð±ÐÃö©ó¿z¿ï¤£«ü©wÄæ¦ìªº¤½¦¡¼gªk?

[µ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ªºÄæ¦ì¬O­nKEYIN¸ê®Æªº¦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ªº¦Û°Ê¥[Á`°µªº..

ÁÂÁÂ

A11=IF((A8<>"")*(A9<>"")*(A10=""),COUNTA(A$2:A10),"")
¤U©Ô  ,A11·|ªÅ¥Õ ,A12¬°µ²ªG ;A11¿é¤J¸ê®Æ ,A12·|ªÅ¥Õ ,A13¬°µ²ªG

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD