How can I get the sum of a column with an arbitrary number of rows?

  • Thread starter Thread starter Mike F.
  • Start date Start date
M

Mike F.

I am trying to get one cell to return the value of an entire column on
another worksheet for which the last row is always changing. If I use:

=SUM(Sheet1!$A$2:A25)

Then the cel will be broken once I add a row 26 to Sheet 1.

What I would like to do is create a sum of the column no matter how
many rows there are.

Thanks.
 
Mike F. said:
I am trying to get one cell to return the value of an entire column on
another worksheet for which the last row is always changing. If I use:

=SUM(Sheet1!$A$2:A25)

Then the cel will be broken once I add a row 26 to Sheet 1.

What I would like to do is create a sum of the column no matter how
many rows there are.

Thanks.
Click to expand...

=SUM(Sheet1!$A$2:A65536)
 
Oh yea, didn't think about that one :)

Guess that what happens when your brain stops functioning without warning.
 
Back
Top