Sum info from columns to rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Remove the $ signs
-----Original Message-----
I am trying to sum info from columns on a worksheet to
Click to expand...
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.
 
(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
 
Back
Top