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

[µo°Ý] Ãö©óSUMPRODUCTªº¥Îªk¬O§_¥i¥H¹ï·Ó¤ë¥÷?(¤w¸Ñ¨M¡AÁÂÁ¤j¤j­Ì)

[µo°Ý] Ãö©óSUMPRODUCTªº¥Îªk¬O§_¥i¥H¹ï·Ó¤ë¥÷?(¤w¸Ñ¨M¡AÁÂÁ¤j¤j­Ì)

¥»©«³Ì«á¥Ñ av8d ©ó 2012-5-29 12:49 ½s¿è

=SUMPRODUCT(--(Data!A:A=Month(A:A)=1,--(Data!B:B="¦¬¤J"),Data!C:C)

¿ù»~ÂI¦bData!A:A=Month(A:A)=1

¤@¯ë§Ú­Ì§ìA2Àx¦s®æ¨ú¤ë¥÷   Month(A2)

¦pªG¬O§ìA¦Cªº1¤ë¥÷¸Ó«ç»ò¼g©O?

=Month(Data!A:A)=1

TOP

¦^´_ 2# ANGELA


    ©Ò¥H¬O=SUMPRODUCT(--(MONTH(Data!A:A)=1),--(Data!B:B="¦¬¤J"),Data!C:C)
¥i¬O·|¥X²{#VALUE

TOP

¦^´_ 3# av8d


=SUMPRODUCT((MONTH(Data!A1:A65535)=1)*(Data!B1:B65535="¦¬¤J")*Data!C1:C65535)

TOP

¦^´_ 3# av8d


    2003ª©ªºexcel¤£¯à¤Þ¥Î¾ãÄæ
      ª`·N¦p¨S¦³¨ä¥L±ø¥ó§PÂ_¥i¯à·|¦³°ÝÃD.
    °²³]A20¬OªÅ®æ¨ºmonth(A20)ªº­È¤]¬O1
    ªÅ®æªºyear()¬O1900,month()¬O1,day()¬O0

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD