how to make the formula effect on the whole sheet.
如何在整张纸上制作配方效果。
the format is : get each lines number sum. then substract some numbers.
格式为:获取每行数和。然后减去一些数字。
eg: there are 100 lines records. how to make the formula effects on each lines?
例如:有100行记录。如何在每一行上制作公式效果?
namely : A1+B1+C1+D1+....equals a number, then using the number-20 -15....
即:A1 + B1 + C1 + D1 + ....等于一个数字,然后使用数字-20 -15 ....
each line using the same way, thank you.
每一行都用同样的方式,谢谢。
2 个解决方案
#1
8
You can input a range into =SUM() like this:
你可以输入一个范围到= SUM(),如下所示:
=SUM(A1:X1)
This calculates the sum of the 1. line from A to X. Just copy/paste the formula to ther rows to calculate the some for those.
这计算从A到X的1.行的总和。只需将公式复制/粘贴到行中以计算那些。
#2
2
Drag the sum down in corner of cell where cursor becomes + sign
在光标变为+符号的单元格的一角向下拖动总和
#1
8
You can input a range into =SUM() like this:
你可以输入一个范围到= SUM(),如下所示:
=SUM(A1:X1)
This calculates the sum of the 1. line from A to X. Just copy/paste the formula to ther rows to calculate the some for those.
这计算从A到X的1.行的总和。只需将公式复制/粘贴到行中以计算那些。
#2
2
Drag the sum down in corner of cell where cursor becomes + sign
在光标变为+符号的单元格的一角向下拖动总和