Need help changing a long formula without doing it manually

[qlo_0lp]

Hey guys

Ok, so I have some really long Sumifs formulas with around 20 Criteria's. The problem is sometimes I need the same formula but just change all the criterias from one column to another.

A good example is the following.

"=(SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"LGP-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"LGT-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"LCM-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"TWQ-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"IST-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"LGO-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"LCS-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"LCA-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"IJR-Rev-KWD")+SUMIFS('RM Summarized'!$I:$I,'RM Summarized'!$O:$O,'Main Sheet'!$A3,'RM Summarized'!$D:$D,"WKL-Rev-KWD"))"

This is a short one that I have and what I wanted to do is basically Copy it to another cell and change all the "$I,$I" columns to lets say "$S,$S". What I currently do is open the formula and change it manually which takes a looong time. Is there a faster way to get this done?

Only thing that I thought about it to paste it on word or something and do a replace all "$O,$O" to "$S,$S" though not sure that will work.

Thanks in advance.

[NeedForExcel]

You can remove the equals sign, which essentially changes the Formulas to a Text String.. Then Use Find & Replace as you normally would on a text string to replace values.. Then add the Equals sign again.. And you are good to go!

[qlo_0lp]

Thanks a lot man :D

[NeedForExcel]

Glad it helped!