我有个2200行左右的excel表，在A列每行都用到数组公式。
A2=MAX(R2,S2)-SUM(SUMIFS(N:N,P:P,P2,E:E,{"1","2","31","32","81","82","83","84","85","86","87","88","89","91","99","100","109","110","111"}))

多个值那部分，是我自定义的一些记号，方便我分门别类的，并不是单纯的数值。

这个表要频繁刷新、筛选。每次筛选或取消筛选，都很慢，要5-8秒这样。
16核CPU，excel计算时显示“正在计算（4个处理器）”

各位大神，能否优化下计算？在线等，急
--
FROM 220.173.103.*