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

½Ð±Ð¡G¦X¨ÖÀx¦s®æ¥[Á`³]©w

¦^´_ 10# leiru


    =SUMIFS(B:B,C:C,F20,A:A,$E$13)

  ¥t¥~¡A«e­±´¿°Q½×¹Lªº°ÝÃD¡A·Q¨ì¤@­Ó¸Ñªk¡A¦pªG¦³<¤Î>²Å¸¹ªÌ¡A¸ê®Æ¤S¬O¤å¦r«¬¼Æ¦r¡A¥i¥[­Ó * ¨Ó³B²z¡A¨Ò «D7070 ¥i¥Î "<>*7070" §@±ø¥ó

TOP

¦^´_ 11# KCC


    ÁÂÁ¸ѵª,­Y¨Ì­ì¤½¦¡G2,½Ð°Ý¡GG13¤½¦¡­n¦p¦ó­×§ï?
joyce

TOP

¦^´_ 12# leiru


    mª©µ¹ªº¤½¦¡¬O°t¦X§Aªº «Dxxxx ±ø¥ó¡A¨ú ¥þ³¡-xxxx
    ¦Ó§A·sªº­pºâ¬O ³æ¯Â¨ú²Å¦X xxxx ¡A¨âªÌÅ޿褣¦P¡A³o¤è­±®¤À°¤£¤W¦£

TOP

¦^´_ 13# KCC


    ÁÂÁ»¡©ú
joyce

TOP

G13:
=SUMPRODUCT((A$2:A$7201&""=E$13&"")*(C$2:C$7201=F13),B$2:B$7201)

TOP

G2 ¤U©Ô
=SUMPRODUCT(NOT(ISNUMBER(FIND($A$2A$7201,$E$2)))*($C$2C$7201=F2)*$B$2B$7201)
G13 ¤U©Ô
=SUMPRODUCT(ISNUMBER(FIND($A$2A$7201,$E$13))*($C$2C$7201=F13)*$B$2B$7201)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD