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

¨ú¥N¨Iªøªº¤½¥Ü

¨ú¥N¨Iªøªº¤½¥Ü

¦U¦ì«e½ú§A­Ì¦n!!
  1. =IF(TODAY()<$A$4,0,SUM(SUM(­º­¶!BC$3:BD$3,INT(AH$5*­º­¶!BB$3),SUM(­º­¶!BC$4:BD$4,INT(AH$5*­º­¶

  2. !BB$4),SUM(­º­¶!BC$5:BD$5,INT(AH$5*­º­¶!BB$5),SUM(­º­¶!BC$6:BD$6,INT(AH$5*­º­¶!BB$6),SUM(­º­¶!BC

  3. $7:BD$7,INT(AH$5*­º­¶!BB$7),SUM(­º­¶!BC$8:BD$8,INT(AH$5*­º­¶!BB$8),SUM(­º­¶!BC$9:BD$9,INT(AH$5*­º

  4. ­¶!BB$9),SUM(­º­¶!BC$10:BD$10,INT(AH$5*­º­¶!BB$10),SUM(­º­¶!BC$11:BD$11,INT(AH$5*­º­¶!BB$11),SUM(­º

  5. ­¶!BC$12:BD$12,INT(AH$5*­º­¶!BB$12),SUM(­º­¶!BC$13:BD$13,INT(AH$5*­º­¶!BB$13),SUM(­º­¶!BC$14:BD

  6. $14,INT(AH$5*­º­¶!BB$14),SUM(­º­¶!BC$15:BD$15,INT(AH$5*­º­¶!BB$15),SUM(­º­¶!BC$16:BD$16,INT(AH$5*­º

  7. ­¶!BB$16),SUM(­º­¶!BC$17:BD$17,INT(AH$5*­º­¶!BB$17),SUM(­º­¶!BC$18:BD$18,INT(AH$5*­º­¶!BB$18),SUM(­º

  8. ­¶!BC$19:BD$19,INT(AH$5*­º­¶!BB$19),SUM(­º­¶!BC$20:BD$20,INT(AH$5*­º­¶!BB$20),SUM(­º­¶!BC$21:BD

  9. $21,INT(AH$5*­º­¶!BB$21),SUM(­º­¶!BC$22:BD$22,INT(AH$5*­º­¶!BB$22),SUM(­º­¶!BC$23:BD$23,INT(AH$5*­º

  10. ­¶!BB$23),SUM(­º­¶!BC$24:BD$24,INT(AH$5*­º­¶!BB$24),SUM(­º­¶!BC$25:BD$25,INT(AH$5*­º­¶!BB$25),SUM(­º

  11. ­¶!BC$26:BD$26,INT(AH$5*­º­¶!BB$26),SUM(­º­¶!BC$27:BD$27,INT(AH$5*­º­¶!BB$27),SUM(­º­¶!BC$28:BD

  12. $28,INT(AH$5*­º­¶!BB$28),SUM(­º­¶!BC$29:BD$29,INT(AH$5*­º­¶!BB$29),SUM(­º­¶!BC$30:BD$30,INT(AH$5*­º

  13. ­¶!BB$30),SUM(­º­¶!BC$31:BD$31,INT(AH$5*­º­¶!BB$31),SUM(­º­¶!BC$32:BD$32,INT(AH$5*­º­¶!BB$32),SUM(­º

  14. ­¶!BC$33:BD$33,INT(AH$5*­º­¶!BB$33),SUM(­º­¶!BC$34:BD$34,INT(AH$5*­º­¶!BB$34),SUM(­º­¶!BC$35:BD

  15. $35,INT(AH$5*­º­¶!BB$35),SUM(­º­¶!BC$36:BD$36,INT(AH$5*­º­¶!BB$36),SUM(­º­¶!BC$37:BD$37,INT(AH$5*­º

  16. ­¶!BB$37),SUM(­º­¶!BC$38:BD$38,INT(AH$5*­º­¶!BB$38),SUM(­º­¶!BC$39:BD$39,INT(AH$5*­º­¶!BB$39),SUM(­º

  17. ­¶!BC$40:BD$40,INT(AH$5*­º­¶!BB$40),SUM(­º­¶!BC$41:BD$41,INT(AH$5*­º­¶!BB$41),SUM(­º­¶!BC$42:BD

  18. $42,INT(AH$5*­º­¶!BB$42),SUM(­º­¶!BC$43:BD$43,INT(AH$5*­º­¶!BB$43),SUM(­º­¶!BC$44:BD$44,INT(AH$5*­º

  19. ­¶!BB$44),SUM(­º­¶!BC$45:BD$45,INT(AH$5*­º­¶!BB$45),SUM(­º­¶!BC$46:BD$46,INT(AH$5*­º­¶!BB$46),SUM(­º

  20. ­¶!BC$47:BD$47,INT(AH$5*­º­¶!BB$47),SUM(­º­¶!BC$48:BD$48,INT(AH$5*­º­¶!BB$48),SUM(­º­¶!BC$49:BD

  21. $49,INT(AH$5*­º­¶!BB$49),SUM(­º­¶!BC$50:BD$50,INT(AH$5*­º­¶!BB$50),SUM(­º­¶!BC$51:BD$51,INT(AH$5*­º

  22. ­¶!BB$51),SUM(­º­¶!BC$52:BD$52,INT(AH$5*­º­¶!BB52)))))))))))))))))))))))))))))))))))))))))))))))))))))
½Æ»s¥N½X
¥t¤@°ÝÃD¦pªþÀÉ»¡©ú
      ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!¦U¦ì«e½ú!±ß¦w!!

Leo37.rar (192.7 KB)

¥i¥H²¤Æ
=IF(TODAY()<$A$4,0,SUM(­º­¶!BC$3:BD$52)+SUMPRODUCT(INT(AH$5*­º­¶!BB$3:BB$52)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
«e½ú!
         ÁÂÁ¦A¤T!!

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD