Sum info from columns to rows

[Donna]

I am trying to sum info from columns on a worksheet to rows on a different worksheet - sum (a$1:a$40). When I copy my equation down in rows, the column remains static. I need this to change - sum(b$1:b$40) and so on. Is there a way to force the column to change

Your help is greatly appreciated.

 

[JJ]

Remove the $ signs

-----Original Message-----
I am trying to sum info from columns on a worksheet to

rows on a different worksheet - sum (a$1:a$40). When I
copy my equation down in rows, the column remains
static. I need this to change - sum(b$1:b$40) and so on.
Is there a way to force the column to change.

 

[Andy Brown]

(Surprisingly, this seems to work ...)

Let's say your =SUM(Sheet1!A$1:A$40) is in row 1 of the different ws. In row
2, use

=SUM(OFFSET(Sheet1!A$1:A$40,0,ROW()-1))

and copy down.

Rgds,
Andy