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

sumproducts °ÝÃD

sumproducts °ÝÃD

¥»©«³Ì«á¥Ñ mdr0465 ©ó 2017-11-14 20:03 ½s¿è

¦U¦ì:

¦b¬¡­¶ªí "SUMMARY"

"B43"®æ¤½¦¡¬O: =SUMPRODUCT(('NOV''17'!$C$2:$C$181="BBJ")*('NOV''17'!$L$2:$L$181="S")*('NOV''17'!$G$2:$G$181))

"B44"®æ¤½¦¡¬O: =SUMPRODUCT(('NOV''17'!$C$2:$C$181="BBJ")*('NOV''17'!$L$2:$L$181="S")*('NOV''17'!$J$2:$J$181))

¬°¤°»ò¨â±ø¤½¦¡¥u¬O­pºâ¤£¦PªºÄæ¦ì,¦ýµª®×·|¦³¿ù»~©O??

½Ð¦U¦ì½ç±Ð,ÁÂÁÂ

INVOICE SUMMARY.rar (59.26 KB)

¥»©«³Ì«á¥Ñ joblyc017 ©ó 2017-11-15 10:15 ½s¿è

¦^´_ 1# mdr0465

    J17:J39¡A¥H¤½¦¡³]©w¦¨ªÅ­È¡A¤å¦r«¬ºAÄæ¦ì¤£¯àª½±µ¹Bºâ
   
   
    ±N('NOV''17'!$J$2:$J$181)©ñ¤JSUMPRODUCT²Ä¤G­Ó¤Þ¼Æ¡A¥i±N©Ò¦³«D¼Æ­È¸ê®Æªº°}¦C¶µ¥Ø·í¦¨ 0 ¨Ó³B²z¡A¸Ô¤U¹Ï¡G
   

TOP

¦^´_ 2# joblyc017

joblyc017

¯uªºÁÂÁ§AªºÀ°¦£¤Î¦^ÂÐ,

¨ü±Ð¤F, ÁÂÁÂ

TOP

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