Thread: formula references vertical cells in a separate worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote