formula references vertical cells in a separate worksheet

Posted to microsoft.public.excel.worksheet.functions

laralea

Posts: n/a

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!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy cells with formula without references	macsworks	Excel Worksheet Functions	1	November 30th 05 09:04 PM
Comparing a list to a Calendar worksheet.	PatrickL	Excel Worksheet Functions	0	August 25th 05 04:21 PM
Formula works in some cells, doesn't in other	Wowbagger	New Users to Excel	13	June 30th 05 03:21 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet	Alan Bartley	Excel Discussion (Misc queries)	1	April 11th 05 05:21 AM
Heps to design Locked/Unlocked cells in protected worksheet	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 07:09 AM

All times are GMT +1. The time now is 07:02 AM.

Menu

About Us