- ©«¤l
- 60
- ¥DÃD
- 20
- ºëµØ
- 0
- ¿n¤À
- 87
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-4
- ³Ì«áµn¿ý
- 2020-5-25
|
B5:
=SUM(B$1:B4)-SUMIF($A$1A4,"Á`p",B$1:B4)*2
³o¬O¥ý¥[«á´îªk, °Ñ¦Ò§Y¥i(Y¦³¿ù»~µLªkÀˬd)
ã´£³¡ªL µoªí©ó 2020-5-15 11:30
ã´£³¡ªL ¤j¤j«D±`·PÁ±zªº¦^ÂÐ,
«D±`©êºp§Úªí¥Ü¤£²M·¡,¦pªG¬O©T©w¤è¦¡´M§äÁ`¼Æ¦ì¸m§Úª¾¹D¦p¦ó°µªº,
°ÝÃD¦b§Úªºªí·|¤@ª½·s¼W,§Ú·Qn¯à¥Î¨ç¼Æ§ì¥X²Ä¤Gªíªº¾ãÓ¦ì¸m½d³ò,§Ú´N¥i¥HÀ³¥Î¦b¹Ïªí¦Û°ÊÅã¥Ü¤W,
§Ú¬O·Qn³]p¨âӹϪí,¤@Ó¬OÅã¥Ü·s¼Wªº³¡¥÷,²Ä¤GÓ¬OÅã¥Ü«e¤@Óªíªº¼Æ¾Ú,¨C¦¸¥Î©Ôªº«Ü·Ð,
©Ò¥H·Qn¥Î¨ç¼Æ¨Ó§ì¨ú,¹Ï¥Ã»·Åã¥Ü«e¨âÓªíªº¸ê®Æ
¥Ø«e§Ú¥i¥H§ì¨ì¦bAÄæ²Ä¤Gªíªº"¶µ¥Ø"¦ì¸m¸ò"Á`p"¦ì¸m,
ÁÙ®t¤@Ó²Ä7¦Cªº¥k¤è"Á`p"¦ì¸m,
³oÓ¦ì¸m¥Î MATCH("Á`p",¤u§@ªí1!7:7,0) ¬O¥i¥H¨ú±o,
°ÝÃD¨C¦¸·s¼W¸ê®Æªíªº¤º®e¤j¤p³£·|¤£¤@¼Ë,¾ÉP²Ä¤Gªí¥Ø«e¬Ý¨ìªº 7:7 ¦C·|¬O¯B°Êªº,
¦Ó7³oӼƦr§Ú¤w¥i¥H¥Î {=INDEX(SMALL(IF(INDIRECT("'¤u§@ªí1'!$A$1:$A$500")="¶µ¥Ø",ROW(1:500)),ROW(1:500)),2)}³oÓ¨ç¼Æ¨ú±o,
¦ý§Ú¤£ª¾¹Dn¦p¦ó§â¨úªºÈ®M¥Î¦b MATCH ¨ç¼Æ¤º¨ú«Ý¿é¤Jªº "7:7"³oÓÈ,
¥un¥i¥H¨ú¥N©Î¬O¨ä¥L¤è¦¡¥i¥H§ì¥X¯B°Ê¦ì¸m,´N¥i¥H®M¥Î¨ì¹Ï¤W |
|