Thread
:
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable.
View Single Post
#
2
Frank Kabel
Posts: n/a
Hi
see your other post
--
Regards
Frank Kabel
Frankfurt, Germany
wrote:
I have a spreadsheet with daily info over a period of time. Each row
represents a day, with the next row representing then next day; etc
etc.
Columns might be daily sales, daily gm, etc.
I want to sum and average on a week to date and prior week to date
basis.
Using the above formula, I haven't figured out how to nail down the
cell reference. It needs to be something like a vlookup or match
where a cell is identified based on today's date, but I need the cell
reference number.
I tried creating a new column which was =cell("address",data) where
data=cells with the data. I will call this Formula B.
I then created a Formula C in which INDIRECT and VLOOKUP accessed the
data in Formula B, and pointed Formula A (the formula in the Subject
header above) to Formula B. Didn't work.
Any ideas?
Thanks!
Reply With Quote