天气预报 > 生活 > excel表格计算工资总和
excel表格计算工资总和
更新时间: 2021-02-26 23:09:18  

1、假设实发工资Z在F前面有5项内容(为A列到E列):在F列写公式如下:=A1+B1+C1+D1+E1,公式写完后往下拉,一直拉到你想要的位置。

2、假设总计在H列,G列为扣款列,在H列写公式:=F1-G1,公式写完后往下拉,一直拉到你想要的位置。

3、数据实时变化。

关键词: excel 表格 计算 工资 总和

excel表格计算工资总和相关经验

天气预报

最新推荐

页面:/news/view-3356463/ | 耗时:0.2262 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=3356463 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3356463 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3356463 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(3230334,2840207,1137556,2358713,655155,1027782,622531,1236446,2305703,1752990,826449,951410,876241,1524015,2405130,3166080,3179918,392893,2409866,965009,3429545,1588245,1952868,3517963,469203,3358760,3340366,370931,2530837,1151126) ORDER BY field (ArticleID,3230334,2840207,1137556,2358713,655155,1027782,622531,1236446,2305703,1752990,826449,951410,876241,1524015,2405130,3166080,3179918,392893,2409866,965009,3429545,1588245,1952868,3517963,469203,3358760,3340366,370931,2530837,1151126)