Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula references vertical cells in a separate worksheet
Can anyone help with this formula?
The formula references vertical cells in a separate worksheet. The formula works fine when entered manually, but I'd like to copy across row 13 to reference the column values on the 2nd worksheet. I have several rows that I need to use a similar formula in. C13 =(C8-C9-C10)*24*C11*'Monthly Rating'!B3 D13 =(D8-D9-D10)*24*D11*'Monthly Rating'!B4 E13 =(E8-E9-E10)*24*E11*'Monthly Rating'!B5 Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula references vertical cells in a separate worksheet
I should think the following should do:
=(C8-C9-C10)*24*C11*OFFSET('Monthly Rating'!$B$1, COLUMN()-1, 0) HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula references vertical cells in a separate worksheet
I can't help with your formula, but I have a similar question if anyone can
answer it when answering this one. I used your example. What I need is when I copy and paste my formula I want the cell it references on another worksheet to always be the same and not update to the next cell below it. Thanks in advance! C13 =(C8-C9-C10)*24*C11*'Monthly Rating'!B3 D13 =(D8-D9-D10)*24*D11*'Monthly Rating'!B3 E13 =(E8-E9-E10)*24*E11*'Monthly Rating'!B3 "laralea" wrote: Can anyone help with this formula? The formula references vertical cells in a separate worksheet. The formula works fine when entered manually, but I'd like to copy across row 13 to reference the column values on the 2nd worksheet. I have several rows that I need to use a similar formula in. C13 =(C8-C9-C10)*24*C11*'Monthly Rating'!B3 D13 =(D8-D9-D10)*24*D11*'Monthly Rating'!B4 E13 =(E8-E9-E10)*24*E11*'Monthly Rating'!B5 Thanks!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula references vertical cells in a separate worksheet
your help is much appreciated!
"vezerid" wrote: I should think the following should do: =(C8-C9-C10)*24*C11*OFFSET('Monthly Rating'!$B$1, COLUMN()-1, 0) HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cells with formula without references | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) |