如何总结Excel中的每一行? [英] how to to sum each rows in excel?

问题描述

如何使公式作用于整张纸.

how to make the formula effect on the whole sheet.

格式为:获取每行编号的总和.然后减去一些数字.

the format is : get each lines number sum. then substract some numbers.

例如:有100条记录.如何使公式效果在每一行上显示?

eg: there are 100 lines records. how to make the formula effects on each lines?

即:A1+B1+C1+D1+ ....等于一个数字，然后使用数字-20 -15 ....

namely : A1+B1+C1+D1+....equals a number, then using the number-20 -15....

每行使用相同的方式，谢谢.

each line using the same way, thank you.

推荐答案

您可以像这样在=SUM()中输入范围:

You can input a range into =SUM() like this:

=SUM(A1:X1)

这将计算从A到X的1.行的和. 只需将公式复制/粘贴到其他行中，即可计算出相应的行数.

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.

这篇关于如何总结Excel中的每一行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！