Hello, I have the following function in Excel that references tables from different sheets.
=SUMIF(ParentTCA[$ Weighted %Placement],"<>#VALUE!")/SUMIF(ParentTCA[$ Weighted PWP20%],"<>#VALUE!",ParentTCA[ValueUSD])
I need to replace every "ParentTCA" with "TCA" but when I run a find and replace I get an error message saying "There's a problem with this formula". I have tried running the SUBSTITUTE function without any luck. Please help!
=SUMIF(ParentTCA[$ Weighted %Placement],"<>#VALUE!")/SUMIF(ParentTCA[$ Weighted PWP20%],"<>#VALUE!",ParentTCA[ValueUSD])
I need to replace every "ParentTCA" with "TCA" but when I run a find and replace I get an error message saying "There's a problem with this formula". I have tried running the SUBSTITUTE function without any luck. Please help!