我在做Excel表格的时候,其中一个数据是要把后面120张表格同样位置的数据求和,但是提示公式太长,我该怎么设置函数呢?如='1'!C4+'2'!C4+'3'!C4+'4'!C4+'5'!C4+'6'!C4+'7'!C4+'8'!C4+'9'!C4+'10'!C4+'11'!C4+'12'!C4+'13
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/10 17:56:08
![我在做Excel表格的时候,其中一个数据是要把后面120张表格同样位置的数据求和,但是提示公式太长,我该怎么设置函数呢?如='1'!C4+'2'!C4+'3'!C4+'4'!C4+'5'!C4+'6'!C4+'7'!C4+'8'!C4+'9'!C4+'10'!C4+'11'!C4+'12'!C4+'13](/uploads/image/z/11339483-59-3.jpg?t=%E6%88%91%E5%9C%A8%E5%81%9AExcel%E8%A1%A8%E6%A0%BC%E7%9A%84%E6%97%B6%E5%80%99%2C%E5%85%B6%E4%B8%AD%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E6%98%AF%E8%A6%81%E6%8A%8A%E5%90%8E%E9%9D%A2120%E5%BC%A0%E8%A1%A8%E6%A0%BC%E5%90%8C%E6%A0%B7%E4%BD%8D%E7%BD%AE%E7%9A%84%E6%95%B0%E6%8D%AE%E6%B1%82%E5%92%8C%2C%E4%BD%86%E6%98%AF%E6%8F%90%E7%A4%BA%E5%85%AC%E5%BC%8F%E5%A4%AA%E9%95%BF%2C%E6%88%91%E8%AF%A5%E6%80%8E%E4%B9%88%E8%AE%BE%E7%BD%AE%E5%87%BD%E6%95%B0%E5%91%A2%3F%E5%A6%82%3D%271%27%21C4%2B%272%27%21C4%2B%273%27%21C4%2B%274%27%21C4%2B%275%27%21C4%2B%276%27%21C4%2B%277%27%21C4%2B%278%27%21C4%2B%279%27%21C4%2B%2710%27%21C4%2B%2711%27%21C4%2B%2712%27%21C4%2B%2713)
我在做Excel表格的时候,其中一个数据是要把后面120张表格同样位置的数据求和,但是提示公式太长,我该怎么设置函数呢?如='1'!C4+'2'!C4+'3'!C4+'4'!C4+'5'!C4+'6'!C4+'7'!C4+'8'!C4+'9'!C4+'10'!C4+'11'!C4+'12'!C4+'13
我在做Excel表格的时候,其中一个数据是要把后面120张表格同样位置的数据求和,但是提示公式太长,我该怎么设置函数呢?如='1'!C4+'2'!C4+'3'!C4+'4'!C4+'5'!C4+'6'!C4+'7'!C4+'8'!C4+'9'!C4+'10'!C4+'11'!C4+'12'!C4+'13'!C4+'14'!C4+'15'!C4+'16'!C4+'17'!C4+'18'!C4+'19'!C4+'20'!C4+'21'!C4+'22'!C4+'23'!C4+'24'!C4+'25'!C4+'26'!C4+'27'!C4+'28'!C4+'29'!C4+'30'!C4+'31'!C4+'32'!C4+'33'!C4+'34'!C4+'35'!C4+'36'!C4+'37'!C4+'38'!C4+'39'!C4+'40'!C4+'41'!C4+'42'!C4+'43'!C4+'44'!C4+'45'!C4+'46'!C4+'47'!C4+'48'!C4+'49'!C4+'50'!C4+'51'!C4+'52'!C4+'53'!C4+'54'!C4+'55'!C4+'56'!C4+'57'!C4+'58'!C4+'59'!C4+'60'!C4+'61'!C4+'62'!C4+'63'!C4+'64'!C4+'65'!C4+'66'!C4+'67'!C4+'68'!C4+'69'!C4+'70'!C4+'71'!C4+'72'!C4+'73'!C4+'74'!C4+'75'!C4+'76'!C4+'77'!C4+'78'!C4+'79'!C4+'80'!C4+'81'!C4+'82'!C4+'83'!C4+'84'!C4+'85'!C4+'86'!C4+'87'!C4+'88'!C4+'89'!C4+'90'!C4+'91'!C4+'92'!C4+'93'!C4+'94'!C4+'95'!C4+'96'!C4+'97'!C4+'98'!C4+'99'!C4+'100'!C4+'101'!C4+'102'!C4+'103'!C4+'104'!C4+'105'!C4+'106'!C4+'107'!C4+'108'!C4+'109'!C4+'110'!C4+'111'!C4+'112'!C4+'113'!C4+'114'!C4+'115'!C4+'116'!C4+'117'!C4+'118'!C4+'119'!C4+'120'!C4+'121'!C4+'122'!C4
我在做Excel表格的时候,其中一个数据是要把后面120张表格同样位置的数据求和,但是提示公式太长,我该怎么设置函数呢?如='1'!C4+'2'!C4+'3'!C4+'4'!C4+'5'!C4+'6'!C4+'7'!C4+'8'!C4+'9'!C4+'10'!C4+'11'!C4+'12'!C4+'13
=sum('1:122'!C4)