- ©«¤l
- 190
- ¥DÃD
- 16
- ºëµØ
- 0
- ¿n¤À
- 236
- ÂI¦W
- 269
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-8
- ³Ì«áµn¿ý
- 2024-11-3
|
¥»©«³Ì«á¥Ñ aer ©ó 2014-4-16 14:11 ½s¿è
¦^´_ 1# like026
¸Õ¸Õ¬Ý,§@·~¤ñ¨Ò¤u§@ªí¿é¤J¤U¦C¤½¦¡
B2=SUMIFS('§@·~¤é»x-1'!$L$8:$L$16,'§@·~¤é»x-1'!$D$8:$D$16,§@·~¤ñ¨Ò!$A2,'§@·~¤é»x-1'!$H$8:$H$16,"<>«¤u")
C2=SUMIFS('§@·~¤é»x-2'!$L$8:$L$16,'§@·~¤é»x-2'!$D$8:$D$16,§@·~¤ñ¨Ò!$A2,'§@·~¤é»x-2'!$H$8:$H$16,"<>«¤u")
¿ï¨úB2»PC2 ¦V¤U½Æ»s |
|