I have searched high and low. Is there a way to find several #REF ! in a formula string within a range (B11:AP55) in a single worksheet and replace it with a "Master".
=SUMIFS(INDEX(#REF !,0,MATCH('SITE'!AP$3,#REF !,0)),#REF !,'SITE'!$A11,#REF !,'SITE'!$A$45)