I want to mass-change the functions of this whole column to follow

SUMIFS(($P$2:$P$49,$O$2:$O$49, "(Text)")

To

SUMIFS(($P$2:$P$49,$N$2:$N$49, "(Text)")

CodePudding user response：

Jaliming,

Just highlight the formulas then do a Find & Replace (Ctrl H) In your case replace $D with $O$49 and $C with $N$49 then hit replace all. Make sure you have the Look in: Formulas set!

CodePudding user response：

and replace $O$2 with $N$2 please check 1 answer