ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°ÝÃö©ó¸ó¦~«×¤é¸ê®ÆÂà¶g¥­§¡°ÝÃD

½Ð°ÝÃö©ó¸ó¦~«×¤é¸ê®ÆÂà¶g¥­§¡°ÝÃD

½Ð°Ý¦U¦ì¥ý¶i:
¤é¸ê®Æ(¥²¶·««ª½¤è¦V)¨Ì¤é´Á¼W¥[³vµ§Áä¤J,¦P®É±N¤é¸ê®ÆÂର¶g¥­§¡¸ê®Æ.
¦ý¦³¨Ç¬P´Á¬O¸ó¦~«×,¨Ò¦p¦~«×³Ì«á¸ê®Æ¶g¥­§¡­Èµ§¼Æ¬O3µ§´N¨ú3µ§¥[Á`¥­§¡.
½Ð°Ý¦p¦ó§PÂ_!ÁÂÁÂ
¸ê®Æ¦pªþ¥ó

¶g¥­§¡¸ó¦~«×test.rar (57.74 KB)

TOP

¥»©«³Ì«á¥Ñ 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ªí

TOP

·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¨Ì¦~«×¨Ó°Ï¤À?
ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD