求和公式Sheet1!A2Sheet2!A1+Sheet1!A2Sheet2!A2+Sheet1!A3*Sheet2!A3

日期：2011-12-14 17:38:44 人气：1

求和公式Sheet1!A2*Sheet2!A1+Sheet1!A2*Sheet2!A2+Sheet1!A3*Sheet2!A3

=SUMPRODUCT(Sheet1!A1:A3,Sheet2!A1:A3)