作业帮帮我套一下那个公式吧,怎么套=(SUM(销售清单!AC15:AC21)+SUM(销售清单!AC28:AC44)+SUM(销售清单!AC25)+SUM(销售清单!AC65)+SUM(销售清单!AC68:AC70))*0.5+(SUM(销售清单!AC77:AC79)+SUM(销售清单!AC6:AC14))*0.3+(SUM(销售
来源：学生作业帮助网 编辑：作业帮 时间：2024/05/04 10:32:34
帮我套一下那个公式吧,怎么套=(SUM(销售清单!AC15:AC21)+SUM(销售清单!AC28:AC44)+SUM(销售清单!AC25)+SUM(销售清单!AC65)+SUM(销售清单!AC68:AC70))*0.5+(SUM(销售清单!AC77:AC79)+SUM(销售清单!AC6:AC14))*0.3+(SUM(销售
帮我套一下那个公式吧,怎么套
=(SUM(销售清单!AC15:AC21)+SUM(销售清单!AC28:AC44)+SUM(销售清单!AC25)+SUM(销售清单!AC65)+SUM(销售清单!AC68:AC70))*0.5+(SUM(销售清单!AC77:AC79)+SUM(销售清单!AC6:AC14))*0.3+(SUM(销售清单!AC22:AC26)+SUM(销售清单!AC45:AC59)+SUM(销售清单!AC61:AC63)+SUM(销售清单!AC66:AC67)+SUM(销售清单!AC75:AC76))*1+(SUM(销售清单!AC60)+SUM(销售清单!AC64)+SUM(销售清单!AC27))*2+(SUM(销售清单!AC71:AC74)+SUM(销售清单!AC80:AC81))*0.1
=(sum(offset(销售清单!$ac$15,2*(column(a1)-1),7))+sum(offset(销售清单!$ac$28,2*(column(a1)-1),17))+offset(销售清单!$ac$65,2*(column(a1)-1))+sum(offset(销售清单!$ac$68,2*(column(a1)-1),3)))*0.5
把公式套成这个样子
帮我套一下那个公式吧,怎么套=(SUM(销售清单!AC15:AC21)+SUM(销售清单!AC28:AC44)+SUM(销售清单!AC25)+SUM(销售清单!AC65)+SUM(销售清单!AC68:AC70))*0.5+(SUM(销售清单!AC77:AC79)+SUM(销售清单!AC6:AC14))*0.3+(SUM(销售
条件和上次提问的一样吗?
也就是上面的是N8的公式,O8则变成了AE列是吗?
N8输入公式:
=(sum(offset(销售清单!$ac$15,2*(column(a1)-1),7))+sum(offset(销售清单!$ac$28,2*(column(a1)-1),17))+offset(销售清单!$ac$25,2*(column(a1)-1))+offset(销售清单!$ac$65,2*(column(a1)-1))+sum(offset(销售清单!$ac$68,2*(column(a1)-1),3)))*0.5+(sum(offset(销售清单!$ac$77,2*(column(a1)-1),3))+sum(offset(销售清单!$ac$6,2*(column(a1)-1),9)))*0.3+(sum(offset(销售清单!$ac$22,2*(column(a1)-1),5))+sum(offset(销售清单!$ac$45,2*(column(a1)-1),15))+sum(offset(销售清单!$ac$61,2*(column(a1)-1),3))+sum(offset(销售清单!$ac$66,2*(column(a1)-1),2))+sum(offset(销售清单!$ac$75,2*(column(a1)-1),2)))*1+(offset(销售清单!$ac$60,2*(column(a1)-1))+offset(销售清单!$ac$64,2*(column(a1)-1))+offset(销售清单!$ac$27,2*(column(a1)-1)))*2+(sum(offset(销售清单!$ac$71,2*(column(a1)-1),4))+sum(offset(销售清单!$ac$80,2*(column(a1)-1),2)))*0.1