Is there a way or formula in the excel that could help to add the nearest
month to get the figure for Column F.
The month added up can be greater than or equal to Column F.
Column A to E is the month.
Column F is the Qty.
Column G is the column that I wish to get the month.

Jan-09 Feb-09 Mar-09 Apr-09 May-09 Qty Ans
100 100 100 100 100 300 Mar,Apr and May-3 mth to
get 300
100 100 100 100 100 250 Mar,Apr and May-3 mth to
have 250
100 100 100 100 100 500 Jan to May-5 month to get
500
100 100 100 100 100 100 May-1 month to get 100
100 100 100 100 100 50 May-1 month to get 50