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

sum(¦WºÙ½d³ò)¥i¥H¦Û°Ê­×§ï

sum(¦WºÙ½d³ò)¥i¥H¦Û°Ê­×§ï

­º¥ý,§Ú¤w¸g§â¨C¤ëªº³øªí,©w¸q¦WºÙ¬°¤ë¥÷¦W
±µ¤U,§Ú§Æ±æ·í§Ú¿ïI1¬°"January"®É,I2ªº¤½¦¡¥i¥H¦Û°Ê¬°sum(January)
·í§Ú¿ï'February"®É,I2¤½¦¡¥i¥H¦Û°Ê¥[Á`=SUM(February)
½Ð°Ý¦³¥i¯à¶Ü Book2.zip (4.53 KB)

¦^´_ 1# VANESSA
§R°£­ì¦³ªº©w¸q¦WºÙ
·s¼W©w¸q¦WºÙx
=OFFSET(Sheet1!$A$3,,MATCH(Sheet1!$I$1,Sheet1!$2:$2,0)-1,COUNT(INDEX(Sheet1!$A:$F,,MATCH(Sheet1!$I$1,Sheet1!$2:$2,0))))
I2=SUM(x)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁÂ,¦¨¥\¤F,¥t½Ð±Ð¬°¤°»ò­n¼gSheet1!$A$3 ?

TOP

¦pªGI2ªº¤½¦¡­n±ø¥ó¦¡¥[Á`¡A¥u¥[Á`$B$3¨ì$B$14¶}ÀY¬°112,­ì¥»§Ú·Q­×§ïAÄ欰 LEFT(B3,3) ±NI2­×§ï¬°SUMIF(A3 :A14,"112',x)¦ý¬O¥¢±Ñ¤F,½Ð°Ý¦³¨ä¥L¸Ñªk¶Ü

TOP

¦^´_ 4# VANESSA

    §A¤v©w¸q¦W¡A¥i¥Îindirect() ª½±µ¤Þ¥Î

    =SUMPRODUCT((LEFT(B3:B14,3)="112")*(INDIRECT(I1)))

TOP

¥Ø«eÁÙ¬O¥H­×§ïAÄ欰 LEFT(B3,3) ±NI2­×§ï¬°SUMIF($A$3A$14,"112",(x))¤è¦¡¦¨¥\,§ÚÁ٧䤣¥X¨ä¥L¤èªk

TOP

¦^´_ 6# VANESSA
À³¸Ó¬O¥i¥H¦¨¥\
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh


    ¦¨¥\,ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD