【小白求助】大神如何将外链公式简化

VBA菜鸟学者

有与外链工作表名称是系统导出，无法修改，外链数据公式太长，请问大神如何能简化，是否可以用名称管理器？


=SUMIFS([房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AW$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AW$20000,[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$C$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$C$20000,C6,[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$M$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$M$20000,"签约",[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$20000,{"<>*车*"},[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$20000,{"<>*商*"},[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$20000,">2019/7/31",[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$20000,"<2019/9/1",[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$F$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$F$20000,"<>*SJ*")/SUMIFS([房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AB$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AB$20000,[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$C$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$C$20000,C6,[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$M$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$M$20000,"签约",[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$20000,{"<>*车*"},[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$V$20000,{"<>*商*"},[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$20000,">2019/7/31",[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$AJ$20000,"<2019/9/1",[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$F$4:[房源台账表20190903.xls]adf6d352_07bc_4ae6_b0a0_e97cb97!$F$20000,"<>*SJ*")

VBA菜鸟学者

大神们求解