Excel 2007 : how to specify "all rows" in Cell formula

[gonen]

Hi

How can I specify a range in a cell formula which will :

SUM all "A" column cells in the sheet - from A3 until the last row ?

Please note that the number of rows in the sheet is changed all the time (add/delete)



thanks !!!

[MarvinP]

Hi gonen,

You can use named ranges in formulas and determine the last row using a DYNAMIC Named Range.

http://www.ozgrid.com/Excel/DynamicRanges.htm
http://www.beyondtechnology.com/geeks007.shtml

[gonen]

Thanks for your quick reply...

I thought it will be much easier.....

out of all these samples... how do you Sum a col to the last row... ??

[MarvinP]

Here is an example.

You will need to look at Named Ranges and see what I've done. Also look at the sum formula to see how to specify a dynamic named range.

If you want to sum all values in Col A, you can use "=Sum(A:A)" Is that whay you meant by easier?

[gonen]

Thanks for your sample....

the Sum(A:A) was already sampled somewhere but it does not allow to sum A into the top of col A (recursive issues...)

why not Sum(A3:A65535) ??

[MarvinP]

There are lots of ways to do this problem. I like your answer too, if it works for you.