how to specify "all rows" in Cell formula

**gonen** · 11-20-2011, 12:24 PM

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** · 11-20-2011, 12:39 PM

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** · 11-20-2011, 12:49 PM

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** · 11-20-2011, 12:55 PM

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** · 11-20-2011, 02:04 PM

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) ??