標題: 取代沉長的公示 [打印本頁]

---

作者: myleoyes    時間: 2014-5-28 23:29     標題: 取代沉長的公示

各位前輩你們好!!

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)))))))))))))))))))))))))))))))))))))))))))))))))))))

複製代碼

另一問題如附檔說明
      請知道的前輩,不吝賜教謝謝再三!!各位前輩!晚安!!

---

作者: ML089    時間: 2014-5-29 10:15

可以簡化
=IF(TODAY()<$A$4,0,SUM(首頁!BC$3:BD$52)+SUMPRODUCT(INT(AH$5*首頁!BB$3:BB$52)))

---

作者: myleoyes    時間: 2014-5-29 21:15

回復 2# ML089
前輩!
         謝謝再三!!

---

歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)