Variable Cell Reference

[Mel Luigs]

I have an issue that is beyond my experience and need
your help.

Worksheet 1 starts on 1/1/04 but the other two worksheets
start in later periods depending upon income variables in
worksheet 1. Worksheet 1 calculates the starting dates
for worksheets 2 and 3.

When worksheet 2 starts on 1/22/04 and worksheet 3 starts
on 3/6/04, I don't know how to write a formula to add the
amounts for week 4/5/04 and put it in the same week in
worksheet 1.

I am sure there is a way but I am lost. Thanks for your
assistance !!

 

[JE McGimpsey]

I'm sure your description is very clear in your mind, but it lacks
enough detail for me to figure out what you want. A little more detail
would be helpful, e.g.:

Where are the amounts to be added?
how are the dates organized (e.g., are they by week? by day? in columns?
rows?)
Are amounts in both sheet2 and sheet3 to be added and put in sheet1?

 

[Mel Luigs]

-----Original Message-----
Message unavailable

 

[Mel Luigs]

-----Original Message-----
Message unavailable

Let me add some additional information for clarity.

All 3 worksheets list 52 weeks down starting in row 13
and continuing thru row 64 but all three worksheets start
on a different week with worksheet 1 being the earliest
week and worksheet 3 being the latest week and the
starting weeks for each worksheet is determined by an
income variable on worksheet 1 which is referenced on the
other 2 worksheets.

My issue is how to find the income cell in Column V for a
specific week in both worksheet 2 and 3, and transfer the
sum of both to the same week's cell in worksheet 1.

I hope this provides enough information to provide a
solution for my problem. Thanks