How to Stop formulas from changing globally

Berto D

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?

Paul Newcome

Happy to help. 👍️

Mike TV

@Berto D

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?

Berto D

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.

Paul Newcome

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

Berto D

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

Paul Newcome

Happy to help. 👍️