取代沉長的公示

各位前輩你們好!!

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