- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 278
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-24
|
¦^´_ 3# pampam
AÄæ¨Ã«D¥¿½T¤é´Á¡A·|³Q»~§P¦¨¦r¦ê
½Æ»s¨ì¨ä¥L¤u§@ªí·|²£¥Í¿ù»~¡A¬O¦]¬°¨Ï¥Î¥~³¡°Ñ·Ó'S1'!$A$2ªº½t¬G
¸Õ¸Õªþ¥ó
B2=IF($C2="","",LOOKUP(2,1/((§÷®Æ!$L$4:$L$14=$C2)*(§÷®Æ!$B$4:$B$14=$A$2)),§÷®Æ!$A$4:$A$14))
D2=IF($C2="","",LOOKUP(2,1/((§÷®Æ!$L$4:$L$14='S1'!$C2)*(§÷®Æ!$B$4:$B$14='S1'!$A$2)),§÷®Æ!$K$4:$K$14))
E2=IF($C2="","",SUM($D$1:D2))
F2=IF($C2="","",LOOKUP(2,1/((§÷®Æ!$L$4:$L$14='S1'!$C2)*(§÷®Æ!$B$4:$B$14='S1'!$A$2)),§÷®Æ!$M$4:$M$14))
§÷®ÆÁ`ªí.rar (7.73 KB)
|
|