infinity?

  • Thread starter Thread starter jacob farino
  • Start date Start date
J

jacob farino

How do you specify infinity? for instance, (b:b) is all values in b. but
what if i wish to exclude one cell, like (b4:b40) and then (b42: and on)?
 
Hi Jacob!

It depends upon the situation. Formula? Range in a Macro? More
specifics needed.
 
I have a TOTALS row on row 41 in a sheet. I'd like to keep it there, so i
can see it w/out having to scroll down. but as i add data below the 41st
row, i need my sum and count formulas to read the data below.

for instance, i have this formula in the B column: =COUNTA(B4:B40). What do
i add to it to make it count everything after 41 too. (or if you have a
better way of displaying totals, that'll work too!

Thanks,
Jacob
 
Hi Jacob!

Why not include the row 41 data in your base formula and then deduct:

eg

=sum(B4:B500)-B41
 
Hi!

I usually include the totals row as the first row below the colum
headings and then freeze it in position with the headings.
It would avoid your problem.

Al
 
Have you given any thought to placing your totals row at the *top* of the
sheet, right under your column labels.
That way you could then use "Freeze Panes", and have the headers and totals
visible at all times.

You could easily accomplish this without having to rework/revise your totals
formulas by simply inserting a new row under the column labels row.

Now, select the cells with the totals formulas, right click in the selection
and choose "Copy", navigate to the top of the sheet and right click in the
first cell of the new row, choose "PasteSpecial", and finally click on the
"PasteLink" button.

This gives you a "linked" copy of the actual totals row, which will update
automatically to display the totals as the data in the totals row changes.
 
Back
Top