| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stumped
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
Post your formula.
-- Brevity is the soul of wit. "Jake" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
=IF(Sheet1!F1="Monday",Sheet1!D9,"")
"Dave F" wrote: Post your formula. -- Brevity is the soul of wit. "Jake" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
Try doing it with the
"Jake" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
Try doing it with the what?
"Steve M" wrote: Try doing it with the "Jake" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stumped with an IF function | Excel Worksheet Functions | |||
| Stumped by a lookup scenario | Excel Worksheet Functions | |||
| Absolutely Stumped! | Excel Discussion (Misc queries) | |||
| Simple But Stumped | Excel Discussion (Misc queries) | |||
| Stumped! Collecting values into one cell. | Excel Worksheet Functions | |||
Hybrid Mode
