½Ð°ÝÃö©ó¸ó¦~«×¤é¸ê®ÆÂà¶g¥§¡°ÝÃD
- ©«¤l
- 38
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2011-7-6
- ³Ì«áµn¿ý
- 2022-3-29
|
½Ð°ÝÃö©ó¸ó¦~«×¤é¸ê®ÆÂà¶g¥§¡°ÝÃD
½Ð°Ý¦U¦ì¥ý¶i:
¤é¸ê®Æ(¥²¶·««ª½¤è¦V)¨Ì¤é´Á¼W¥[³vµ§Áä¤J,¦P®É±N¤é¸ê®ÆÂର¶g¥§¡¸ê®Æ.
¦ý¦³¨Ç¬P´Á¬O¸ó¦~«×,¨Ò¦p¦~«×³Ì«á¸ê®Æ¶g¥§¡Èµ§¼Æ¬O3µ§´N¨ú3µ§¥[Á`¥§¡.
½Ð°Ý¦p¦ó§PÂ_!ÁÂÁÂ
¸ê®Æ¦pªþ¥ó |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
|
|
|
|
|
|
- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-24 17:09 ½s¿è
¦^´_ 1# ten999
¤èªk1:
»²§UÄæC2=YEAR(A2)
»²§UÄæD2=WEEKNUM(A2)
¶g¥§¡E2=SUMPRODUCT(($C$2:$C$1000=C2)*($D$2:$D$1000=D2)*$B$2:$B$1000)/SUMPRODUCT(($C$2:$C$1000=C2)*($D$2:$D$1000=D2))
¤èªk2:
»²§UÄæC2=YEAR(A2)
»²§UÄæD2=WEEKNUM(A2)
¼Ï¶s¤ÀªRªí
|
|
|
|
|
|
|
- ©«¤l
- 38
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- taichung
- µù¥U®É¶¡
- 2011-7-6
- ³Ì«áµn¿ý
- 2022-3-29
|
·PÁª©¥D¦^ÂÐ !
§Q¥Îweeknum()·|¦^¶Ç¶g¼ÆÈ
¦ý¦]¬°§Úªº¶g¥§¡¤½¦¡¬O§Q¥Î sumif()¤Îcountif()¨Ó°µ¶g¥§¡
¦pªG§Q¥Îweeknum()®É,sumif()²Å¦X±ø¥ó·|¥]§t²Ä¤@¦~(1994y)²Ä¤@¶g¤Î¤G¦~²Ä¤@¶g(1995y) 1996y²Ä¤@¶g-------,´N¤£¬O¨Ì¦~«×¨Ó°Ï¤À?
ÁÂÁÂ |
|
|
|
|
|
|