i have a budget for each months expenses. I wish to accumulate the monthly
costs each month by reference to the month I am working with. For example In
month 4 I need each amount appearing on each row to be added togethe, the
totals to appear in column 13. In month 5 I need the totals in column 13 to
represent the addition of each row in columns 1 through 5 and so on. The only
entry I wish to make is to record which month I am workingh with for
reference by the formula

Assuming the monthly data starts in A2:L2, and the total for that row goes in
M2, if you put the month of interest in B1, the formula for M2 is

=SUM(OFFSET(A2,0,0,1,$B$1))

If you type a date in B1, e.g. 10/15/2004, use

=SUM(OFFSET(A2,0,0,1,MONTH($B$1)))


On Sat, 11 Dec 2004 13:57:02 -0800, "Help with algorithm" <Help with
wrote:

i have a budget for each months expenses. I wish to accumulate the monthly
costs each month by reference to the month I am working with. For example In
month 4 I need each amount appearing on each row to be added togethe, the
totals to appear in column 13. In month 5 I need the totals in column 13 to
represent the addition of each row in columns 1 through 5 and so on. The only
entry I wish to make is to record which month I am workingh with for
reference by the formula