Auto sum

[Eileen]

My spreadsheet have weekly sales data. I need to sum up
the data and show monthly total. Currently, I insert one
column =sum(a2:d2). But I need to manually change the
formular every month for example Oct. have 5 weeks.

Is there an easy way I can automatically sum up monthly
total?


9/5/04 9/12/04 9/19/04 9/26/04
2,948 4,527 4,584 2,422

 

[flkulchar]

Why not try conditional formatting for the 5th week; in
other words, if there is a fifth week..., if
not..."column width"=0

larry

 

[Biff]

Hi!

If you mean you are LITERALLY inserting another column in
the sheet:

=SUM(OFFSET($A$2,0,0,1,COUNT($2:$2)+1))

If INSERTING means that you just add another cell to the
formula range, then:

=SUM(OFFSET($A$2,0,0,1,COUNT($2:$2)))

Biff