How to add weekly numbers related to a date.

  • Thread starter Thread starter Andre Ronda
  • Start date Start date
A

Andre Ronda

Simply said but I would like to get a y-t-d total in a array of 52 rows with
a date in the first cell by copying the value from a weekly number related
to a same date.

A1 = date (entered each week)
B1 = number A
C1 = number B
D1 = number C


E1 = Jan 1, 2004
E2 = Jan 8, 2004
E3 = Jan 15, 2004
and so on (52 weeks)
F1 = number A (from B1 related to first date in A1)
F2 = number A (from B1 related to 2nd date in A1)
F3 = number A (from B1 related to 3rd date in A1)
and so on (52 weeks)

F53 = total of all number A in column F

same for number B and number C respectively in columns G and H

From moment that I change date in A1, it re-sets the values in F1, F2, F3,
etc.. Is there a function to keep earlier numbers fixed once I change the
date to a next one? Thnks.

Andre Ronda, Belgium
 
Simply said but I would like to get a y-t-d total in a array of 52
rows with a date in the first cell by copying the value from a weekly
number related to a same date.

A1 = date (entered each week)
B1 = number A
C1 = number B
D1 = number C
E1 = Jan 1, 2004
E2 = Jan 8, 2004
E3 = Jan 15, 2004
Click to expand...

What is in A2, A3, ... , B2, B3, ... ,C2, C3, ... D2, D3, ..?

I'm assuming they're blank.

I think that in order to make this work, you have to enter each date in a
separate row (i.e. enter dates in A1, A2, A3)

Once you have removed or replaced something in a spreadsheet, you can't
do calculations with it anymore.

Make the formula not always refer to A1, but the formulas in row (F2, G2,
H2) should refer to A2.

Look up the difference between absolute and relative cell references.
 
Back
Top