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

¦p¦ó¦b²Ä¤@¦¸¤ñ¹ï§ä¤£¨ì®É¦Û°Ê¦A¤ñ¹ï²Ä¤G±ø¥ó®M¨ú²Å¦Xªº­È??

=IF(SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$B$2:$B$23=B2)*(©ú²Ó!$D$2:$D$23)),SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$B$2:$B$23=B2)*(©ú²Ó!$D$2:$D$23)),SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$C$2:$C$23=B2)*(©ú²Ó!$D$2:$D$23)))

TOP

A2=INDEX(©ú²Ó!$A$1:$A$1000,SMALL(IF(©ú²Ó!$A$2:$A$100<>"",ROW($A$2:$A$100),999),ROW(A1)))&""  °}¦C¤½¦¡
®Æ¸¹¬O­na®Æ¸¹ÁÙ¬Ob®Æ¸¹?¥i¥ÎVLOOKUP§ì¨ú

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD