Column Lengths

[RWiederstein]

Got one range "Data" and one range "Calculations." Each separated by a
blank column. I write a formula into the top column of "Calculation."
I then have to ask,"I wonder how far down I have to paste this
formula?" The answer is, of course, the same number of rows as are in
the "Data" range. Is there an easy way to do this? For example,
F1:Endrow=Forumula? Should I be experimenting with the "offset"
property?

 

[Earl Kiosterud]

R,

Seems to me there's a more direct way than the following, but it's the best
I can do right now.

Put something in the last cell of Calculations. If it's a long way down,
you can find the last row by selecting any cell in column Data and press
Ctrl-Down. Now type something into the last cell of Calculations. Your
cat's name will do.

Now select and copy your formula from the first cell of the Data column.
There should now be a marquee around the cell.

Press Shift-Ctrl-Down. That should select to the bottom of the Calculation
column, where you put something in the first step.

Press Enter. That will do a paste into all the selected columns.

Instead of all this, you can, after putting your formula in the first cell
of Calculations and selecting it, copy down by dragging the Fill Handle
(lower right corner of the cell). If you drag beyond the lower edge of the
screen, do so carefully, or it'll auto-scroll very fast and make you say bad
words. Stop when you see you've reached the last row. If you've dragged
too far, just drag back.

 

[Roger Govier]

Hi

If you are wanting to sum the values then
=SUM(F2:INDEX(F:F,COUNTA(D)))

But if there is no data further down the column anyway, you could just
use
=SUM(F:F)