sum up

[jillzz]

Ok I'm really new at this and trying to learn on the fly. I know my questions are very basic. If i want to sum a column where I know the range will be ever changing, what is the most efficient way to write the code.

Thanks for you help in advance.

If there is a newbie area let me know and I'll go there. Or a basic tutorial to help me walk through simple formulas and such.

Jill

 

[NBVC]

Usually something like

=Subtotal(9,A1:a100) will allow you to add lines and also works when filtering.

otherwise = Sum(A1:A100).

Adjust ranges to suit.

 

[Aladin Akyurek]

Ok I'm really new at this and trying to learn on the fly. I know my questions are very basic. If i want to sum a column where I know the range will be ever changing, what is the most efficient way to write the code.

Thanks for you help in advance.

If there is a newbie area let me know and I'll go there. Or a basic tutorial to help me walk through simple formulas and such.

Jill

=SUM(A:A)

or

=SUM(A2:A65536)

 

[jillzz]

But that gives me a circular reference in the same column.

 

[Aladin Akyurek]

But that gives me a circular reference in the same column.

Put the formula outside column A.

 

[jillzz]

I can't put the formula in another column.
It needs to sum up in the same column or my spreadsheet will be all out of whack. Since other things pull from here.
Is there not another alternative?

 

[Aladin Akyurek]

I can't put the formula in another column.
It needs to sum up in the same column or my spreadsheet will be all out of whack. Since other things pull from here.
Is there not another alternative?

In which cell are you trying to put the formula?

 

[NBVC]

Put this after the last occupied cell in column A and change the A100 to whatever you last occupied cell reference is.

=Subtotal(9,A1:a100)

or =Sum(A1:A100)

 

[jillzz]

The range changes each time I run another worksheet.
I
was trying to avoid having to actually go to the cell and enter a formula of =sum(A1:A24), since next week it might be =sum(A1:a52).

Isn't there a way to name the range based on the cells occupied and then tell it to sum the named range?

sorry, maybe I just don't understand what you are trying to tell me

 

[NBVC]

Did you try the Subtotal formula.

I think that does what you want

=Subtotal(9,A1:a100), If you insert a line above the subtotal cell, it will take that into account when summing.