Hello All,

Ive worked out how to work out how many weeks of stock cover I have using a fab formula I found online and then adjusted.

This is it:

=SUMPRODUCT(--(SUBTOTAL(9,OFFSET(B11:$P11,,,,COLUMN(B11:$P11)-COLUMN(B11)+1))<=B8))+LOOKUP(0,SUBTOTAL(9,OFFSET(B11:$P11,,,,COLUMN(B11:$P11)-COLUMN(B11)+1))-B11:$P11-B8,(B8-(SUBTOTAL(9,OFFSET(B11:$P11,,,,COLUMN(B11:$P11)-COLUMN(B11)+1))-B11:$P11))/B11:$P11)

This looks at my opening stock in cell B8, My Sales forecast for the next 15 weeks in B11:P11 BUT I have a second set where the sales forecast is not input on one row.

Im trying to adjust the formula to look at the sales forecast in cells: D9,G9,J9,M9,P9,S9,V9,Y9,AB9,AE9,AH9,AK9,AN9,AQ9 & AT9

Does anyone know how I can re-write this formula to do this? PLEASE do not suggest a VBA becase I don't get them and don't have the time to try and understand lol!

Thanks in advance to anyon that can help