Find and Replace within a formula?

[olimajor123]

Hi there

Is it possible to find and replace within a formula? IE I have a formula which is a SUMIF and is looking up on 30+ sheets, I want to copy the formula but want to change column N to column X. Is there a way to do this quickly in one go do I have to do it manually?

Thanks

 

[gaz_chops]

No need if you do what I suggested!