- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¦^´_ 5# winint1
A3=IF(D3="","",RANK(D3,$D$3:$D$19))
C3=SUMPRODUCT((MONTH(DATA!$A$6:$A$2475)=¸ê®Æ·J¾ã!$B$1)*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$B3)*(DATA!D$6:D$2475))
D3=IF(C3=0,"",SUM(E3:F3)/C3)
E3=SUMPRODUCT((MONTH(DATA!$A$6:$A$2475)=¸ê®Æ·J¾ã!$B$1)*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$B3)*(DATA!E$6:E$2475))
F3=SUMPRODUCT((MONTH(DATA!$A$6:$A$2475)=¸ê®Æ·J¾ã!$B$1)*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$B3)*(DATA!F$6:F$2475))
¦V¤U½Æ»s
J3=SUMPRODUCT((LOOKUP(DATA!$A$6:$A$2475,¸ê®Æ·J¾ã!$W$2:$W$372,¸ê®Æ·J¾ã!$X$2:$X$372)=LOOKUP(2,1/($J$1:J$1<>""),$J$1:J$1))*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$I3)*(DATA!$E$6:$E$2475))
K3=SUMPRODUCT((LOOKUP(DATA!$A$6:$A$2475,¸ê®Æ·J¾ã!$W$2:$W$372,¸ê®Æ·J¾ã!$X$2:$X$372)=LOOKUP(2,1/($J$1:K$1<>""),$J$1:K$1))*(DATA!$C$6:$C$2475=¸ê®Æ·J¾ã!$I3)*(DATA!$F$6:$F$2475))
J3:K3¦V¥k¦V¤U½Æ»s |
|