Year-to-date row

  • Thread starter Thread starter Steve Mc
  • Start date Start date
S

Steve Mc

I have year-to-date data accumulating in ther H column

YTD

H1 56.0
H2 123.2
H3 225.9
H4
H5
....
H53 225.9 ??

H4 will be YTD for next week, H5 for the following week,
etc.
How can I have H53 change each week to show the actual
YTD data ?

Thanks,

Steve
 
Steve,

=INDEX(A1:A52,COUNT(A1:A52))

This will not work if:
1. You have blank cells before the most recent
OR
2. Cells after the most recent data are NOT blank

Regards,
Felipe
 
This didn't work.
I do have formulas in all the H column cells, formulas
referring to a column on the right :
(=IF(D3=0,D3,D3+H2)
If nothing in that particular week in the D column, then
nothing in the H column. If there is data in the D column
cell, then that plus the previous YTD data in the H
column.
Can the formulas be the problem with the Index, count ?

Thanks again,
Steve
 
Back
Top