- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 46
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2021-4-27
|
¦^´_ 4# louischen1104
=SUMPRODUCT(($A$2:$A$12=F2)*$C$2:$C$12)
©î¸Ñ¤j·§·N«ä¬°
(A2=F2)*C2 A2=F2¦pªG¬°TURE´N¥Nªí1¦pªG¬°False´N¥Nªí0
+(A3=F3)*C3 A3=F3¦pªG¬°TURE´N¥Nªí1¦pªG¬°False´N¥Nªí0
...
+(A12=F12)*C12 A12=F12¦pªG¬°TURE´N¥Nªí1¦pªG¬°False´N¥Nªí0 |
|