Offset/Indirect Help

  • Thread starter Thread starter steven.britton
  • Start date Start date
S

steven.britton

I need to look at a lead time in weeks from column B and locate that
week in a seperate table - then sum the values in that table from the
beginning to that found week. Example:



Weeks 1 2 3 4 Rate 1 1 2 2
Weeks # of Boats
3 Need Formula
4
2
4
The above should return the value of 4 - One in week 1, One in week 2,
and two in week 3.

Thanks
-Steve
 
Please look at your question and ask yourself if anyone could answer it
without knowing how your data is set out. We DO want to help but are not
mind readers.
best wishes
 
Back
Top