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

[µo°Ý] ²Î­p¤£¦PºØÃþ¤f¨ý¼Æ¶q

[µo°Ý] ²Î­p¤£¦PºØÃþ¤f¨ý¼Æ¶q

¦U¦ì¥ý¶i¦n¡A¤p§Ì¦]¤u§@Ãö«Y»Ý¤À§O²Î­p¤£¦P¤f¨ý¼Æ¶q¡A¦ý ²Î­p¤£¦P¤f¨ý¼Æ¶q.rar (4.79 KB) ¤£ª¾¨Ï¥Î¦óºØ¨ç¼Æ¤½¦¡¡A¦pªþÀÉ¡A½Ð¥ý¶i«ü¾É¡AÁÂÁ¡I

¦^´_ 1# shan0948


    C4=SUMIFS(©ú²Óªí!$D$4:$D$34,©ú²Óªí!$B$4:$B$34,$B4,©ú²Óªí!$C$4:$C$34,OFFSET($B$2,--(COLUMN(A1)<4),COLUMN(A1)))
    ¥k©Ô¡A¤U©Ô

TOP

¦^´_ 2# KCC


    KCC¤j¦n¡A¤p§ÌªºExcel¬O2003ª©¡A³o¨ç¼Æ¤½¦¡À³¸Ó¬O2007ª©¨Ï¥Î¡A³Â·Ð¥i¯à­n§ï¨ç¼Æ¡AÁÂÁ¡I

TOP

C4 =SUM((©ú²Óªí!$B$4:$B$34=$B4)*(©ú²Óªí!$C$4:$C$34=C$3)*(©ú²Óªí!$D$4:$D$34))
µM«á«ö CTRL+SHIFT+ENTER  ¼Æ²Õ¤½¦¡

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2017-5-11 17:41 ½s¿è

¦^´_ 3# shan0948


    =SUMPRODUCT(©ú²Óªí!$D$4:$D$34*(©ú²Óªí!$B$4:$B$34=$B4)*(©ú²Óªí!$C$4:$C$34=OFFSET($B$2,SUM(--(COLUMN(A1)<4)),SUM(COLUMN(A1)))))

     or
     =SUMPRODUCT(©ú²Óªí!$D$4:$D$34*(©ú²Óªí!$B$4:$B$34=$B4)*(©ú²Óªí!$C$4:$C$34=OFFSET($B$2,--(COLUMNS($A:A)<4),COLUMNS($A:A))))

TOP

¦^´_ 4# fengetianxia


  ¸g´ú¸Õ«á¥i¥H¥¿±`¨Ï¥Î¡AÁÂÁ¡I

TOP

¦^´_ 5# KCC


    ¸g2003ª©¨Ï¥Î«á¡A¤w¥i¥¿½T²Î­p¼Æ­È¡AÁÂÁ¡I

TOP

¦^´_  KCC


    KCC¤j¦n¡A¤p§ÌªºExcel¬O2003ª©¡A³o¨ç¼Æ¤½¦¡À³¸Ó¬O2007ª©¨Ï¥Î¡A³Â·Ð¥i¯à­n§ï¨ç¼Æ¡AÁÂÁ ...
shan0948 µoªí©ó 2017-5-11 16:35


=SUMPRODUCT((©ú²Óªí!$B$4:$B$34=$B4)*(©ú²Óªí!$C$4:$C$34=C$3)*©ú²Óªí!$D$4:$D$34)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD