- ©«¤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
|
¦^´_ 3# JackieKM
§R°£ì¦³ªº©Ò¦³©w¸q¦WºÙ¡A«·s«Ø¥ß¤w¤U¥|Ó©w¸q¦WºÙ
a
=OFFSET(¤C¤ë¸ê®ÆÁ`ªí!$A$2,,,COUNT(¤C¤ë¸ê®ÆÁ`ªí!$A:$A),16)
x
=COUNTA(OFFSET(¤C¤ë¤é´ÁÁ`ªí!$A$2,,MATCH(¸ê®Æ¬d¸ß!$B$3&¸ê®Æ¬d¸ß!$C$2,¤C¤ë¤é´ÁÁ`ªí!$1:$1,0)-1,50,))
¥æ©ö¤é´Á
=OFFSET(¤C¤ë¤é´ÁÁ`ªí!$A$2,,MATCH(¸ê®Æ¬d¸ß!$B$3&¸ê®Æ¬d¸ß!$C$2,¤C¤ë¤é´ÁÁ`ªí!$1:$1,0)-1,x,)
¥æ©ö´Á§O
=OFFSET(¤C¤ë¤é´ÁÁ`ªí!$B$1,1,,COUNTA(¤C¤ë¤é´ÁÁ`ªí!$B:$B)-1,)
B3ÅçÃÒ²M³æ¨Ó·½
=¥æ©ö´Á§O
C3ÅçÃÒ²M³æ¨Ó·½
=¥æ©ö¤é´Á
B6¤½¦¡
=SUMPRODUCT((INDEX(a,,4)=$D6)*(INDEX(a,,5)=B$4)*(INDEX(a,,1)=$C$3)*(INDEX(a,,3)=$B$3)*INDEX(a,,12))
¦V¤U½Æ»s
E6¤½¦¡
=SUMPRODUCT((INDEX(a,,4)=$D6)*(INDEX(a,,5)=E$4)*(INDEX(a,,1)=$C$3)*(INDEX(a,,3)=$B$3)*INDEX(a,,12))
¦V¤U½Æ»s
¿ï¾ÜÅv - ¤C¤ë.zip (209.39 KB)
|
|