- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¦pªG¤U±ªº¤½¦¡¤¤
=LOOKUP(2,1/(A2:A15=D2),B2:B15)
D2nª½±µ¿é¤J´M§äªº¦r¤¸¡A¦p ST01 ¡B ST02¡BST03...
n¦p¦ó¤@¤f®ð§â§t¦³ST¶}ÀYªº¤@¦¸³£§ä¥X¨Ó?
¦b¥[Á`¹B¥Î®É¡A¥i¥H¨Ï¥Î¥H¤U¤½¦¡
=sumif(A1:A1000,"ST*",B1:B1000)
¦ý·f°tLookup®É¥u»Ýn¶Ç¦^ TRUE ©Î FALSE ®É¸Ó«ç»ò¼g? |
|