Changing one aspect to a formula in multiple cells.

[pat55ski]

=SUMPRODUCT(($K$4:$K$98="x")*(H$4:H$98>=0)*(H$4:H$98<=99)*($CX$4:$CX$98="Sunday"))

how do I change these characters in my formula in numerous cells w/out having to go to each cell and physically changing each and every formula? Lets say I want to change from Cell "K" to Cell "O". Is there a functions I can conduct that will change these cells. Now Some of the formulas have different days in them like Monday-Saturday, I want to keep them constant bit only change the cell. HELP!

[VBA Noob]

Hi,

Try Ctrl + H and Find K and replace with O

Note: Check in options that Link in Formulas is selected

Also it's sometimes better to enter $K$4:$K$98 and $O$4:$O$98 incase you have a K as a condtion

VBA Noob