Updating one formula reference is updating all formula references.
I have several formulas that reference a different sheet. When I update one formula it updates all other formulas that reference that sheet regardless that I've pointed them to different sets of data on that sheet:
For example - the above formula references the sheet Lafayette Square but the column with dollar values that I want it to sum.
This one references the same sheet but a different range on the sheet where I want it to count if the status is complete.
When I try to correct the reference to the correct range it then updates all the formulas that reference that sheet.
I've checked, none of the cells have the Column Formula on them so I don't think that's the issue.
I'm at a total loss...I've never had this happen before so I'm really not sure how to make it stop.
Help Article Resources
Check out the Formula Handbook template!