EXCEL 公式太长什么办 ,3Q=$D87*DL$6+$E87*DL$7+$F87*DL$8+$G87*DL$9+$H87*DL$10+$I87*DL$11+$J87*DL$12+$K87*DL$13+$L87*DL$14+$M87*DL$15+$N87*DL$16+$O87*DL$17+$P87*DL$18+$Q87*DL$19+$R87*DL$20+$S87*DL$21+$T87*DL$22+$U87*DL$23+$V87*DL$24+$W87*DL$25+$X
来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/24 07:37:41
EXCEL 公式太长什么办 ,3Q=$D87*DL$6+$E87*DL$7+$F87*DL$8+$G87*DL$9+$H87*DL$10+$I87*DL$11+$J87*DL$12+$K87*DL$13+$L87*DL$14+$M87*DL$15+$N87*DL$16+$O87*DL$17+$P87*DL$18+$Q87*DL$19+$R87*DL$20+$S87*DL$21+$T87*DL$22+$U87*DL$23+$V87*DL$24+$W87*DL$25+$X
EXCEL 公式太长什么办 ,3Q
=$D87*DL$6+$E87*DL$7+$F87*DL$8+$G87*DL$9+$H87*DL$10+$I87*DL$11+$J87*DL$12+$K87*DL$13+$L87*DL$14+$M87*DL$15+$N87*DL$16+$O87*DL$17+$P87*DL$18+$Q87*DL$19+$R87*DL$20+$S87*DL$21+$T87*DL$22+$U87*DL$23+$V87*DL$24+$W87*DL$25+$X87*DL$26+$Y87*DL$27+$Z87*DL$28+$AA87*DL$29+$AB87*DL$30+$AC87*DL$31+$AD87*DL$32+$AE87*DL$33+$AF87*DL$34+$AG87*DL$35+$AH87*DL$36+$AI87*DL$37+$AJ87*DL$38+$AK87*DL$39+$AL87*DL$40+$AM87*DL$41+$AN87*DL$42+$AO87*DL$43+$AP87*DL$44+$AQ87*DL$45+$AR87*DL$46+$AS87*DL$47+$AT87*DL$48+$AU87*DL$49+$AV87*DL$50+$AW87*DL$51+$AX87*DL$52+$AY87*DL$53+$AZ87*DL$54+$BA87*DL$55+$BB87*DL$56+$BC87*DL$57+$BD87*DL$58+$BE87*DL$59+$BF87*DL$60+$BG87*DL$61+$BH87*DL$62+$BI87*DL$63+$BJ87*DL$64+$BK87*DL$65+$BL87*DL$66+$BM87*DL$67+$BN87*DL$68+$BO87*DL$69+$BP87*DL$70+$BQ87*DL$71+$BR87*DL$72+$BS87*DL$73+$BT87*DL$74+$BU87*DL$75+$BU87*DL$76+$BU87*DL$77+$BU87*DL$78+$BV87*DL$79+$BV87*DL$80+$BV87*DL$81+$BV87*DL$82+$BW87*DL$83+$BX87*DL$84+$BY87*DL$85
EXCEL 公式太长什么办 ,3Q=$D87*DL$6+$E87*DL$7+$F87*DL$8+$G87*DL$9+$H87*DL$10+$I87*DL$11+$J87*DL$12+$K87*DL$13+$L87*DL$14+$M87*DL$15+$N87*DL$16+$O87*DL$17+$P87*DL$18+$Q87*DL$19+$R87*DL$20+$S87*DL$21+$T87*DL$22+$U87*DL$23+$V87*DL$24+$W87*DL$25+$X
=SUMPRODUCT(TRANSPOSE(A1:A10),C1:L1)
楼主参照此公式,数组,上公式输入完后同时按shift ctrl enter三键结束,上公式的意思是列区域A1:A10,分别对应乘行区域C1:L1后,所有乘后的和