将Excel公式合并到COUNTIF所有选项卡

Question

我目前正在使用一个COUNTIF公式来计算多张纸上的“竞争对手”一词。有没有一个很好的方法来合并这个公式，以便对一系列的工作表运行COUNTIF？

 =COUNTIF('Outside 12.2'!P2:P4977,"Competitor")+COUNTIF('Outside 12.7'!P2:P4977,"Competitor")+COUNTIF('Outside 12.8'!P2:P4977,"Competitor")+COUNTIF('Outside 12.12'!P2:P4977,"Competitor")+COUNTIF('Outside 12.19'!P2:P4977,"Competitor")+COUNTIF('Big East 11.30'!P2:P4977,"Competitor")+COUNTIF('Northern Tier 11.25'!P2:P200,"Competitor")+COUNTIF('Northern Tier 11.23'!P2:P56,"Competitor")+COUNTIF('Northern Tier 1'!P2:P1000,"Competitor")