How to Stop formulas from changing globally
This is my formula...
They look fine across the first row...
But if I copy the formula to another row and change the reference, all the cells change.
This is NOT what I want.
Can anyone help?
Best Answer

Happy to help. 👍️
Answers

You'll have to provide more information. When you say you're changing the reference, you're changing it from what to what? That change could very easily lead to different results. Also, what are the expected results you're looking for?

Thank you, Mike. The formula is referencing another sheet. This one (below).
I want my formulas to perform a COUNTIFS function by pulling from these different columns (above). The first row (below) works fine.
But I write the formula for the second row and I change the reference to another column in the source file, all the formula change (including the formula in first row), which I don't want.
I don't want any of the formula in other rows to change at all, but I seem to have no control of that.

Instead of clicking on "Edit Reference", highlight the entire cross sheet reference so that it changes to "Reference another sheet".

I'll give it a try. Thank you, Paul.

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!