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

¦p¦ó¨D¨C¤é°â»ù¤p­p¤Î¨C¤éÀu´f»ù¤p­p

¦p¦ó¨D¨C¤é°â»ù¤p­p¤Î¨C¤éÀu´f»ù¤p­p

½Ð°Ý¦¹ÀɮתºF40¤ÎF41Àx¦s®æ¤½¦¡­n¦p¦ó³]©w
ÁÂÁÂ

¶i¾P¦s.rar (12.26 KB)

joyce

F40=SUMPRODUCT(($D$2:$D$35=$D$2)*(F$2:F$35=1)*$E$2:$E$35)
F41=SUMPRODUCT(($D$2:$D$35=$D$3)*(F$2:F$35=1)*$E$2:$E$35)

TOP

¦^´_ 1# leiru


    F40=SUMPRODUCT(($D$2:$D$35=$D2)*($E$2:$E$35)*(F$2:F$35))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤£¦n·N«ä, ½Ð®e§Ú´£¤@­Ó°ÝÃD.
¦b "°â»ù¨C¤é¾P°â¼Æ¶q"  & "Àu´f»ù¨C¤é¾P°â¼Æ¶q" ªº¤½¦¡¬O¤£¬O¥Î
=SUMIF($D$2:$D$35,$D$2,F$2:F$35) ¤ñ¸ûª½±µ,²³æ¤@ÂI?

=SUMPRODUCT((MOD(ROW($F$2:$F$36),2)=0)*1,$F$2:$F$36)
¤£ª¾¹D³o­Ó¤½¦¡¦p¦ó¸ÑÄÀ?

·PÁÂ !!
fangac

TOP

¦^´_ 4# fangsc
·íµM­pºâ¼Æ¶q¥ÎSUMIF§Y¥i
¦ý­Y²o¯A¨ìª÷ÃB¡A¥²¶·¼Æ¶q*ª÷ÃB«á¥[Á`

=SUMPRODUCT((MOD(ROW($F$2:$F$36),2)=0)*1,$F$2:$F$36)
§Ú·Q±z¤£À´ªºÀ³¬OMOD¨º¬q
±N¦C¼Æ°£¥H2ªº¾l¼Æ­Y¬°0¡A´N¬O°¸¼Æ¦C¬°±ø¥ó¦¨¥ß
¦Ó*1¬O±N­ì¥»¬°ÅÞ¿è­Èªº°}¦CÂন¼Æ値°}¦C
¤£Âন¼Æ­Èª½±µ¥Î*¸¹´N·|¦³¬Û¦P®ÄªG
=SUMPRODUCT((MOD(ROW($F$2:$F$36),2)=0)*$F$2:$F$36)
³o¼Ëºâ¥X¨Ó¤]¬O¼Æ¶q¡A¨Ã«D¾P°âÃB
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# Hsieh


   ¤F¸Ñ, ·PÁª©¥Dªº¸Ñ»¡.
fangac

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD