天气预报 > 生活 > Excel中两列数的乘积求和
Excel中两列数的乘积求和
更新时间: 2021-04-15 21:00:03  

1、运用公式直接单项相乘求和。

2、在总价数值框中输入公式:=SUMPRODUCT()。

3、在输入的公式后面的括号里先选定要单项相乘的第一列加进去。

4、在后面加入“,”再在后面输入另一列要单项相乘的数列。点击回车(Enter)就可以得到最后要求的数值了。

关键词: excel 乘积 求和

Excel中两列数的乘积求和相关经验

天气预报

最新推荐

页面:/news/view-655155/ | 耗时:0.7484 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=655155 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=655155 LIMIT 0,1
select * from tbl_Articles_sphinx where id=655155 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1125578,1071277,1059318,1119520,1125086,1106467,1125610,1121382,1111798,1043043,1074912,1114356,1104923,1123897,1125574,1113047,1042654,1097119,1114514,1067914,1085254,1089086,1085792,1099749,1095582,1112036,1112024,1126148,1105405,1121280) ORDER BY field (ArticleID,1125578,1071277,1059318,1119520,1125086,1106467,1125610,1121382,1111798,1043043,1074912,1114356,1104923,1123897,1125574,1113047,1042654,1097119,1114514,1067914,1085254,1089086,1085792,1099749,1095582,1112036,1112024,1126148,1105405,1121280)