=IF(ISNUMBER(初验前运维!IJ20),初验前运维!IJ20,0)+IF(ISNUMBER(初验前运维!IN20),初验前运维!IN20,0)+IF(ISNUMBER(初验前运维!IR20),初验前运维!IR20,0)+IF(ISNUMBER(!IV20),初验前运维!IV20,0)+IF(ISNUMBER(#REF!IZ20),#REF!IZ20,0)+IF(ISNUMBER(#REF!JD20),#REF!JD20,0)+IF(ISNUMBER(#REF!JH20),#REF!JH20,0)+IF(ISNUMBER(#REF!JL20),#REF!JL20,0)+IF(ISNUMBER(#REF!JP20),#REF!JP20,0)+IF(ISNUMBER(#REF!JT20),#REF!JT20,0)+IF(ISNUMBER(#REF!JX20),#REF!JX20,0)+IF(ISNUMBER(#REF!KB20),#REF!KB20,0)+IF(ISNUMBER(#REF!KF20),#REF!KF20,0)+IF(ISNUMBER(#REF!KJ20),#REF!KJ20,0)+IF(ISNUMBER(#REF!KN20),#REF!KN20,0)+IF(ISNUMBER(#REF!KR20),#REF!KR20,0)+IF(ISNUMBER(#REF!KV20),#REF!KV20,0)+IF(ISNUMBER(#REF!KZ20),#REF!KZ20,0)+IF(ISNUMBER(#REF!LD20),#REF!LD20,0)+IF(ISNUMBER(#REF!LH20),#REF!LH20,0)
as you see, the formula like this. it has 350 columns in workSheet ‘初验前运维’, and i sum some cells in other sheet. then there’s something wrong with the formula.
My project waiting for this.
Help.
事件ID 7001
ID: 1, Application Name: Microsoft Office Excel, Application Version: 12.0.6683.5002, Microsoft Office Version: 12.0.6612.1000. This session lasted 49 seconds with 0 seconds of active time. This session ended with a crash.