- ©«¤l
- 72
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 126
- ÂI¦W
- 0
- §@·~¨t²Î
- W7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-4-2
- ³Ì«áµn¿ý
- 2016-1-14
|
¦^´_ 3# renzhi2020
C2 Y=IF(ISERROR(LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)))),0,LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)),(G2:G22)))
n½Æ»s®É¦n¹³´N¦³°ÝÃD
¬O§_À³¥[¤W$ C2=IF(ISERROR(LOOKUP(2,1/((E$2:E$22=A2)*(F$2:F$22=B2)))),0,LOOKUP(2,1/((E$2:E$22=A2)*(F$2:F$22=B2)),(G$2:G$22)))
½Æ»s®É¸û¤è«K |
|