WOS

[tracy]

Is there a way in Excel to calculate out the weeks of
supply? For example: product xyz has a wos of 8, how can
I find out how many units I need to have on hand today to
cover the next 8 weeks of demand? Note, the wos can be
different for every product. Thank you!

 

[Glenn Schwandt]

Assuming WOS in A1 and wk1...wk26 forecast in A2:Z2 (or however far you go):

A3=SUM(INDIRECT(ADDRESS(ROW()-1,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN()+$A$1)
))

 

[Glenn Schwandt]

Your welcome! Just trying to give a little back...

THANK YOU GLENN!! I really appreciate your help with
this. With a little adjustment to the formula, it worked
perfectly and you also introduced me to the world of
arrays that I know will make my job much easier. Thank
you again!

<SNIP>