How to SUM for indeterminate number of rows?
 

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

How to SUM for indeterminate number of rows?
 

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

On Feb 20, 1:02*am, MrNobody
wrote:
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

How to SUM for indeterminate number of rows?
 

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!

"Pete_UK" wrote:

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

On Feb 20, 1:02 am, MrNobody
wrote:
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

How to SUM for indeterminate number of rows?
 

On Thu, 19 Feb 2009 17:30:01 -0800, MrNobody
wrote:

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

How to SUM for indeterminate number of rows?
 

On Feb 19, 5:02*pm, MrNobody
wrote:
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.

How to SUM for indeterminate number of rows?
 

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

MrNobody wrote:
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!

"Pete_UK" wrote:

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

On Feb 20, 1:02 am, MrNobody
wrote:
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