OfficeÖЇø(gu¨®)Õ“‰¯/AccessÖЇø(gu¨®)Õ“‰¯
˜Ë(bi¨¡o)î}:
Õˆ(q¨«ng)½ÌÈçºÎ·Ö½M½y(t¨¯ng)Ó‹(j¨¬)”µ(sh¨´)Á¿£¬ÖxÖx£¡£¡£¡
[´òÓ¡±¾í“]
×÷Õß:
xiaocgogo
•r(sh¨ª)ég:
2012-5-31 12:14
˜Ë(bi¨¡o)î}:
Õˆ(q¨«ng)½ÌÈçºÎ·Ö½M½y(t¨¯ng)Ó‹(j¨¬)”µ(sh¨´)Á¿£¬ÖxÖx£¡£¡£¡
È總ˆDËùʾ£¬ÀýÈçÎÒºYßx¡°½»Ø›µØ=½·½Íâɳ¡±•r(sh¨ª)£¬ÏÂÃæСӋ(j¨¬)¾ÍÊÇËùÓн»Ø›µØžé½·½ÍâɳµÄ¿‚Ó‹(j¨¬)£¬ÎÒÔ‡Á˺ܶ๫ʽ²»ÐУ¬Õˆ(q¨«ng)ŽÍ濴һϣ¬ÖxÖx£¡£¡
[attach]49287[/attach]
[attach]49288[/attach]
×÷Õß:
pureshadow
•r(sh¨ª)ég:
2012-6-1 07:06
=SUM(SUBTOTAL(9,OFFSET($K1,SMALL(IF(D23=$J2:$J20,ROW(1:19),20),ROW(1:19)),)))
ctrl+shift+enter½Y(ji¨¦)Êø£¬ÓÒÀ¡£
šgÓ¹âÅR OfficeÖЇø(gu¨®)Õ“‰¯/AccessÖЇø(gu¨®)Õ“‰¯ (http://ctxi.cn/)
Powered by Discuz! X3.3