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

¿z¿ï¥[Á`

¿z¿ï¥[Á`

¦U¦ì«e½ú§A­Ì¦n!!   
         °ÝÃD¦pªþÀÉ»¡©ú
         ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!

Leo36.rar (110.53 KB)

¦^´_ 2# aer
«e½ú!
           ÁÂÁÂ!!³o½d¨Ò¬O¥Ñµ{¦¡¦Û°Ê¿z¿ï©Ò¥H¤½¦¡
           ¤p§Ì­×§ï¦p¤U
          [F1] = "=SUMIFS(D2:D888,A2:A888,A1,B2:B888,"">""&EDATE(B1,-12)+1,B2:B888,""<=""&B1,D2:D888,"">100"")"
          [G1] = "=SUMIFS(G2:G888,A2:A888,A1,B2:B888,"">""&EDATE(B1,-12)+1,B2:B888,""<=""&B1,G2:G888,"">100"")"
           ÁÂÁ¦A¤T!!

TOP

¥»©«³Ì«á¥Ñ aer ©ó 2013-11-11 20:51 ½s¿è

¹Ï¤@    F1=SUMIFS(D295,D295,">100",B2:B95,"<="&DATEVALUE("2000/12/31"))
            G1=SUMIFS(G2:G95,G2:G95,">100",B2:B95,"<="&DATEVALUE("2000/12/31"),A2:A95,1)

¹Ï¤G    F1=SUMIFS(D295,A2:A95,2,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),D295,">100")
            G1=SUMIFS(G2:G95,A2:A95,2,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),G2:G95,">100")

¹Ï¤T    F1=SUMIFS(D295,A2:A95,1,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),D295,">100")
            G1=SUMIFS(G2:G95,A2:A95,1,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),G2:G95,">100")

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD