If you're experiencing issues with reference cells changing formulas while working with averaging and IFs in indirect functions, this article provides potential solutions.