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

myleoyes

¦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. 
   
3. !BB$4),SUM(­º­¶!BC$5:BD$5,INT(AH$5*­º­¶!BB$5),SUM(­º­¶!BC$6:BD$6,INT(AH$5*­º­¶!BB$6),SUM(­º­¶!BC
   
4. 
   
5. $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*­º
   
6. 
   
7. ­¶!BB$9),SUM(­º­¶!BC$10:BD$10,INT(AH$5*­º­¶!BB$10),SUM(­º­¶!BC$11:BD$11,INT(AH$5*­º­¶!BB$11),SUM(­º
   
8. 
   
9. ­¶!BC$12:BD$12,INT(AH$5*­º­¶!BB$12),SUM(­º­¶!BC$13:BD$13,INT(AH$5*­º­¶!BB$13),SUM(­º­¶!BC$14:BD
   
10. 
    
11. $14,INT(AH$5*­º­¶!BB$14),SUM(­º­¶!BC$15:BD$15,INT(AH$5*­º­¶!BB$15),SUM(­º­¶!BC$16:BD$16,INT(AH$5*­º
    
12. 
    
13. ­¶!BB$16),SUM(­º­¶!BC$17:BD$17,INT(AH$5*­º­¶!BB$17),SUM(­º­¶!BC$18:BD$18,INT(AH$5*­º­¶!BB$18),SUM(­º
    
14. 
    
15. ­¶!BC$19:BD$19,INT(AH$5*­º­¶!BB$19),SUM(­º­¶!BC$20:BD$20,INT(AH$5*­º­¶!BB$20),SUM(­º­¶!BC$21:BD
    
16. 
    
17. $21,INT(AH$5*­º­¶!BB$21),SUM(­º­¶!BC$22:BD$22,INT(AH$5*­º­¶!BB$22),SUM(­º­¶!BC$23:BD$23,INT(AH$5*­º
    
18. 
    
19. ­¶!BB$23),SUM(­º­¶!BC$24:BD$24,INT(AH$5*­º­¶!BB$24),SUM(­º­¶!BC$25:BD$25,INT(AH$5*­º­¶!BB$25),SUM(­º
    
20. 
    
21. ­¶!BC$26:BD$26,INT(AH$5*­º­¶!BB$26),SUM(­º­¶!BC$27:BD$27,INT(AH$5*­º­¶!BB$27),SUM(­º­¶!BC$28:BD
    
22. 
    
23. $28,INT(AH$5*­º­¶!BB$28),SUM(­º­¶!BC$29:BD$29,INT(AH$5*­º­¶!BB$29),SUM(­º­¶!BC$30:BD$30,INT(AH$5*­º
    
24. 
    
25. ­¶!BB$30),SUM(­º­¶!BC$31:BD$31,INT(AH$5*­º­¶!BB$31),SUM(­º­¶!BC$32:BD$32,INT(AH$5*­º­¶!BB$32),SUM(­º
    
26. 
    
27. ­¶!BC$33:BD$33,INT(AH$5*­º­¶!BB$33),SUM(­º­¶!BC$34:BD$34,INT(AH$5*­º­¶!BB$34),SUM(­º­¶!BC$35:BD
    
28. 
    
29. $35,INT(AH$5*­º­¶!BB$35),SUM(­º­¶!BC$36:BD$36,INT(AH$5*­º­¶!BB$36),SUM(­º­¶!BC$37:BD$37,INT(AH$5*­º
    
30. 
    
31. ­¶!BB$37),SUM(­º­¶!BC$38:BD$38,INT(AH$5*­º­¶!BB$38),SUM(­º­¶!BC$39:BD$39,INT(AH$5*­º­¶!BB$39),SUM(­º
    
32. 
    
33. ­¶!BC$40:BD$40,INT(AH$5*­º­¶!BB$40),SUM(­º­¶!BC$41:BD$41,INT(AH$5*­º­¶!BB$41),SUM(­º­¶!BC$42:BD
    
34. 
    
35. $42,INT(AH$5*­º­¶!BB$42),SUM(­º­¶!BC$43:BD$43,INT(AH$5*­º­¶!BB$43),SUM(­º­¶!BC$44:BD$44,INT(AH$5*­º
    
36. 
    
37. ­¶!BB$44),SUM(­º­¶!BC$45:BD$45,INT(AH$5*­º­¶!BB$45),SUM(­º­¶!BC$46:BD$46,INT(AH$5*­º­¶!BB$46),SUM(­º
    
38. 
    
39. ­¶!BC$47:BD$47,INT(AH$5*­º­¶!BB$47),SUM(­º­¶!BC$48:BD$48,INT(AH$5*­º­¶!BB$48),SUM(­º­¶!BC$49:BD
    
40. 
    
41. $49,INT(AH$5*­º­¶!BB$49),SUM(­º­¶!BC$50:BD$50,INT(AH$5*­º­¶!BB$50),SUM(­º­¶!BC$51:BD$51,INT(AH$5*­º
    
42. 
    
43. ­¶!BB$51),SUM(­º­¶!BC$52:BD$52,INT(AH$5*­º­¶!BB52)))))))))))))))))))))))))))))))))))))))))))))))))))))

½Æ»s¥N½X

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

ML089

¥i¥H²¤Æ
=IF(TODAY()<$A$4,0,SUM(­º­¶!BC$3:BD$52)+SUMPRODUCT(INT(AH$5*­º­¶!BB$3:BB$52)))

myleoyes

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