求和公式=Sheet1!A1*Sheet2!A1+Sheet1!A2*Sheet2!B1+Sheet1!A3*Sheet2!C1
求和公式=Sheet1!A1*Sheet2!A1+Sheet1!A2*Sheet2!B1+Sheet1!A3*Sheet2!C1
日期：2011-12-14 18:01:55 人气：3
=SUM(TRANSPOSE(Sheet1!A1:A3)*Sheet2!A1:C1)
按Ctrl+Shift+Enter
求和公式=Sheet1!A1*Sheet2!A1+Sheet1!A2*Sheet2!B1+Sheet1!A3*Sheet2!C1