Given the formula I gave earlier, if I copy it to another column to the right, it keeps all the values I need changed with the alt 4 function.

I need to copy everything and paste over a column, but I can't due to all the formulas have a $ in the addition portion. When I do this, it shifts the first variable while keeping the rest. I want to highlight the entire colomn and have it pick up all the information to the column to the right.

I don't really know how else to word it. I want the same formula but over one column, the issue is that I already have a $ function so it doesn't shift. I'd have to manually highlight that section and then press f4.