EXCEL公式太长，急，

来源：百度知道 编辑：UC知道 时间：2024/06/23 03:43:50
SUM('K001'!K10,'k002'!K10,'K003'!K10,'K004'!K10,'K005'!K10,'K006'!K10,'K007'!K10,'K008'!K10,'K009'!K10,'K010'!K10,'K011'!K10,'K012'!K10,'K013'!K10,'K014'!K10,'K015'!K10,'K016'!K10,'K017'!K10,'K018'!K10,'K019'!K10,'K020'!K10,'K021'!K10,'K022'!K10,'K023'!K10,'K024'!K10,'K025'!K10)+SUM('K026'!K10,'K027'!K10,'K028'!K10,'K029'!K10,'K030'!K10,'K031'!K10,'K032'!K10,'K033'!K10,'K034'!K10,'K035'!K10,'K036'!K10,'K037'!K10,'K038'!K10,'K039'!K10,'K040'!K10,'K041'!K10,'K042'!K10,'K043'!K10,'K044'!K10,'K045'!K10,'K046'!K10,'K047'!K10,'K048'!K10,'K049'!K10,'K050'!K10)+SUM('K051'!K10,'K052'!K1

=SUM('K001':'K100'!k10)
先写上=SUM()，然后把鼠标放入括号内，然后按住SHIFT键，将表格1-100全部选中然后点击K10单元格，确定，OK

直接在放结果的单元格输入公式
=sum(k001:k100!k10)，就ok 了