- ©«¤l
- 146
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 220
- ÂI¦W
- 0
- §@·~¨t²Î
- 7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2014-2-19
- ³Ì«áµn¿ý
- 2023-8-31
|
¦^´_ 4# Andy2483
«D±`·PÁÂandy«e½úªºÀ°¦£¡Aexcelªº¯à¤O¯uªº¥O¤H¨ØªA¡C·Q½Ð°Ý¦pªGn¦Û¾Ç³o¨ÇVBA¡B¦Ûq¨ç¼Æ¡A¦³þ¨Ç±ÀÂ˪º®ÑÄy¶Ü? ·P®¦
-----
¥t¥~·Q½Ð°Ý¡G
¦pªG¤£¬O¥ÎVBA©Î¬O¥¨¶°ªº¸Ü¡A¨Ò¦p¡A§Ú±ø¥ó¬O¡uR1~R3¡vªºÈ¡C¦bI2¤½¦¡¹Á¸ÕµÛ¥Î¥H¤U¤è¦¡¡AÁöµM¥i¥H§e²{¡A¦ý¯Ê¥F¤@¨Ç¼u©Ê¦Ó¥B¤¾ªø¡G
=INDEX(A:D,MATCH("R1",A:A,0),MATCH(I1,A1:D1,0))+INDEX(A:D,MATCH("R2",A:A,0),MATCH(I1,A1:D1,0))+INDEX(A:D,MATCH("R3",A:A,0),MATCH(I1,A1:D1,0))
·Q½Ð°Ý¡A³oÓ¤½¦¡¦³¨S¦³¥i¥H§ï¶iªºªÅ¶¡©Î¬O¥t¤@ºØ¼gªk©O? ÁÂÁ±z¡C |
|