SHEET2 B1=SHEET1!B7 SHEET2 C1=SHEET1!B8 SHEET2 B2=SHEET1!B10

来源：学生作业帮编辑：搜搜考试网作业帮分类：综合作业时间：2024/07/31 10:03:04

SHEET2 B1=SHEET1!B7 SHEET2 C1=SHEET1!B8 SHEET2 B2=SHEET1!B10 SHEET2 C2=SHEET1!B11 以此类推

=INDIRECT("Sheet1!B"&3+ROW()*3+COLUMN(A1))
=OFFSET(Sheet1!$B$6,(ROW(A1)-1)*3+COLUMN(A1),)
=INDEX(Sheet1!$B:$B,3+ROW(A1)*3+COLUMN(A1))
三个公式选其一即可.
再问：说错了 SHEET2! B4= SHEET1! B7 SHEET1! B5=SHEET2!B8 SHEET2! B6= SHEET1! B10 SHEET1! B7=SHEET2!B11 SHEET2! B8= SHEET1! B13 SHEET1! B9=SHEET2!B14
再答：除第一个公式改为 =INDIRECT("Sheet1!B"&3+ROW(A1)*3+COLUMN(A1)) 其他两个公式可以直接用。
再问： SHEET2! B15= SHEET1! F7 SHEET1! B16=SHEET2!F8 SHEET2! B17= SHEET1! F10 SHEET1! B18=SHEET2!F11 SHEET2! B19= SHEET1! F13 SHEET1! B20=SHEET2!F14
再答：将公式中的B改成F，比如 =INDIRECT("Sheet1!F"&3+ROW(A1)*3+COLUMN(A1))

Sheet1.Range("a1") = Sheet2.Range("a1") * Sheet2.Range("h1") 我要使得sheet2中 A1=sheet1!B1,A2=sheet1!B13,A3=sheet1!B25,A4=shee 老问题sheet2的B2=vlookup(A2,sheet1!A:C,2,0) C2=vlookup(A2,sheet1 关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Shee 在excel中如何实现Sheet1表中A1=Sheet2中A1,Sheet1表中A4=Sheet2中A2,Sheet1表求和公式Sheet1!A2*Sheet2!A1+Sheet1!A2*Sheet2!A2+Sheet1!A3*Sheet2 建二个电子表格Sheet1、Sheet2,在Sheet1中有二列数值：A1 A2 A3 A4 B1 B2 B3 B4 我 =OFFSET(sheet1!$C$1:$R$1,--(sheet2!$P$6)*8,sheet2!$B$2+0)这个是 exce中l Excel中 sheet2中有个的公式 =SUM(Sheet1!A1:A5),与=SUM(Sheet1!$ Excel中如何让sheet1中的B2填充sheet2中J19,让sheet1中的C2填充sheet2中J22,以此类推 EXCEL公式：如何让SHEET2中的A1等于SHEET1中的A1+B1；而且下拉后A2=D1+E1,A3=G1+H1. excel2003中在SHEET3表中A2单元给计算公式=SHEET1!A1+SHEET2!B2是那些数的计算?