Thread: Coppy formula using OFFSET
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric_G Eric_G is offline
external usenet poster
  
Posts: 41
Default Coppy formula using OFFSET
I am attempting to create a worksheet formula as follows:

Cell A3 is to reflect the PRODUCT of Cells A1:A3 on Worksheet2.
Cell A4 is to reflect the PRODUCT of Cells A4:A6 on Worksheet2.
Cell A5 is to reflect the PRODUCT of Cells A7:A9 on Worksheet2, and so on.

Unfortunately, when I copy the formula from Cell A3 to A4, I'm not using the
OFFSET function properly. Any suggestions?
Reply With QuoteReply With Quote