Is it possible to create some VBA to replace one part of an array formula? I'm concerned because of the whole shift-cntrl-enter thing.

Current formula(s) - actually about 20 versions of this exact formula with a different cell reference other than K13

{=SUM(IF((allbudgetentered[Goal]=K13),IF(allbudgetentered[Funding Source]="TARDIS",allbudgetentered[Amount],0)))}

The only change I need to make is to the "TARDIS" part (I made it silly and Whovian just for fun while tweaking...but obviously it needs to read the appropriate funding source now - BORING!)

Since I have several other changes that I need to make on several dozen spreadsheets, I'd like to add it to the other coding I have and just do the fixes all at once.

So how can I replace every instance of "TARDIS" with something boring and adult like "Internal Revenue" or "Donations/In Kind"?


PS - I still plan on using Doctor Who references during all of my building and tweaking.