- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-3
|
D2=INDEX(¶µ¥Ø©ú²Ó!D:D,MATCH(B2,¶µ¥Ø©ú²Ó!F:F,))
(µL¶·H:L¦C ,¥ÎFIND)E2:E6{=IF(B2=G2,0,SUM((¶µ¥Ø©ú²Ó!C$2:C$8=A2)*IF(ISERR(FIND(B2,¶µ¥Ø©ú²Ó!F$2:F$8)),,¶µ¥Ø©ú²Ó!D$2:D$8)))
OR
E2:E6=IF(B2=G2,0,SUMIFS(¶µ¥Ø©ú²Ó!D$2:D$8,¶µ¥Ø©ú²Ó!C$2:C$8,A2,¶µ¥Ø©ú²Ó!F$2:F$8,"*"&B2&"*")) |
|