I am using a conditional formula to display the sum of an equation on a
different worksheet. The conditional formula looks at the day of the week
that is entered by the user to determine where to put the sum of the
equation. My problem is that when the day of the week is changed, the data
referenced from the other worksheet will be lost. Is there some way to
reference data from a different worksheet and lock those values in place so
they will not change when the day of the week changes?