Cross-sheet formulas - affecting two cells when only one selected
I am cross-referencing "total paid" from a budget sheet into an over all activity sheet; however, I have two cells (in the activity sheet) that though I am selecting different sets of figures (from the budget sheet) in the formulas they keep reflecting the other. when i change one, it changes the other. and visa versa. its like hey are linked. but i haven't linked them ???
Help Article Resources
Check out the Formula Handbook template!