How to SUM for indeterminate number of rows?

[MrNobody]

I have a column of numbers starting at cell B3. The number of rows is not
fixed - it changes. How do I write one SUM function to sum everything from B3
to the last number, whatever row it might be on?

Is there a way to combine it with the COUNT function to accomplish this goal?

Please show me an example

 

[Pete_UK]

You could just do:

=SUM(B:B)

as long as the formula is not in column B - it will ignore blanks and
text.

Hope this helps.

Pete

 

[MrNobody]

The only problem is this seems to sum the entire column.

I need it to start summing at B3 down to whatever is left, because on the
first two rows are numbers I don't want included in the summing.

Any way to do that?

Thanks!

 

[Ron Rosenfeld]

The only problem is this seems to sum the entire column.

I need it to start summing at B3 down to whatever is left, because on the
first two rows are numbers I don't want included in the summing.

Any way to do that?

Thanks!

Then just do something like =sum(b3:b65535) or some other number large enough
to encompass your entire potential used range.
--ron

 

[joeu2004]

I have a column of numbers starting at cell B3.
The number of rows is not fixed - it changes.
How do I write one SUM function to sum everything
from B3 to the last number, whatever row it might
be on?

There are several ways to do this, but which one is best depends on
the circumstances. One common way is to always be sure there is a
blank cell (or a cell with text, like a title) at least at the end,
and perhaps even before, the column of numbers that you want to sum
over. For example, if B2 is a title, you currently have values in
B3:B10 and B11 is empty, you could write SUM(B2:B11). Then, if you
insert rows after B2 or B10 or you delete rows, the B11 in the SUM
range will be changed automagically.

If that approach does not work for your situation, I suggest that you
post a reply with more details about your situation.

 

[David Biddulph]

In that case, why not =SUM(B:B)-SUM(B1:B2) ?