owen06

¦^´_ 1# eghost


    §ï¦¨³o¼Ë´N¦æ¤F
    =SUMPRODUCT((MONTH(i3:i37)=7)*1)

owen06

¦^´_ 3# eghost


    ¦ó¥²°õµÛ©ócountif¡Asumproduct¥i¥H¹B¥Îªº¼h­±§ó¼s¡A¬Ý§A¬O­n¤T¥|¤­¤»¤C±ø¥ó³£ÀH«K§A¡AÁÙ¥i¥HÀ°§A¥[Á`²Å¦X¥H¤W±ø¥óªº¼Æ¶q¡A
    ¥u­n¤@­ÓÀx¦s®æ¡A´N¯à­pºâ¥X²Å¦X¦h±ø¥óªº¼Æ¶q©ÎÁ`¶q¡A¦nsumproduct¡A¤£¥Î¶Ü~

    ¦Ü©ócountif¬°¤°¤£¯à¨º¼Ëºâ¤é´Áªº°ÝÃD¡A¥i¯à´N­n½Ðª©¤Wªº¶W¯Å°ª¤â¨Ó¸Ñ´b¤F¡C

owen06

¦^´_ 5# eghost


    ¦pªG¤@©w­n¥Îcountif¥hºâªº¸Üoffice2003­n³o¼Ë=COUNTIF(I:I,">"&DATE(2014,6,30))-COUNTIF(I:I,">"&DATE(2014,7,31))
    §A¦pªG¬Ooffice2007¥i¥H¥Î=COUNTIFS(A:A,">2014/6/30",A:A,"<2014/7/31")
    ¦ý¬O§Úı±o¦³ÂI¤Ó³Â·Ð¡C
    §ÚÁÙ¬O«Øij§A¥h¥Îsumproduct¨Ó¼g¡A¦]¬°¤@¨Ó¤½¦¡¤º®e¸û²©ö¡A¥B¥i¥H¦h±ø­pºâ¡A¥i¥H¬Ù¤U«Ü¦h³Â·Ð¡A
    ¤j¬ù»¡©ú¤@¤Usumproduct±ø¥óªº¥Îªk
    =sumproduct((«ü©wªº½d³ò=«ü©wªº±ø¥ó)*(«ü©wªº½d³ò=«ü©wªº±ø¥ó)*1)===>­pºâ¥X²Å¦X¤W­z±ø¥óªº¶µ¥Ø¼Æ¡A¥i¥H«ü©w«Ü¦h±ø¥ó³£¨S°ÝÃD
    =sumproduct((«ü©wªº½d³ò=«ü©wªº±ø¥ó)*(«ü©wªº½d³ò=«ü©wªº±ø¥ó),­n¥[Á`½d³ò)===>­pºâ­n¥[Á`ªº½d³ò¤º¡A²Å¦X¤W­z±ø¥ó¶µ¥ØªºÁ`¦X

   §A¥i¥H¸ÕµÛ±N§A­nªºªí¥Îsumproduct°µ°µ¬Ý¡A¦pªG¦³°ÝÃDªº¸Ü¡A¦A´£¥X¨Ó¤@°_°Q½×¡C

owen06

©êºp¸É¥R¤@¤U¡A2003ªº¥Î  =COUNTIF(A:A,">2014/6/30")-COUNTIF(A:A,">2014/7/31")   ´N¦æ¤F