Sum of a column from nth row to end

I want to total a column from D3 to the end of D column (I don't know the
end) and place that sum in D1.
Please help !! Urgent !!

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know the
end) and place that sum in D1.
Please help !! Urgent !!

Luke,
I know I could do that but I was thinking whether we have some other options
if we don't want to sum that long.
I know we can sum a whole column using SUM(D) but you cannot place that
SUM in the same column.

"Luke M" wrote:

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know the
end) and place that sum in D1.
Please help !! Urgent !!

In article ,
itsAchint wrote:

I want to total a column from D3 to the end of D column (I don't know the
end) and place that sum in D1.
Please help !! Urgent !!


Try...

=SUM(D3:INDEX(D365536,MATCH(9.99999999999999E+30 7,D365536)))

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

Alternative ideas:

=SUM(OFFSET(D3,0,0,COUNT(D365536),1))
Offset creates a range with height based on number of numbers in column D.

=SUM(INDIRECT("D3"&COUNT(D365536)+3))
Indirect lets you manually create a reference, control row number via COUNT
in this example (but you could use a cell reference)

The SUM function is rather efficient however, so I would recommend just
going with that.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

Luke,
I know I could do that but I was thinking whether we have some other options
if we don't want to sum that long.
I know we can sum a whole column using SUM(D) but you cannot place that
SUM in the same column.

"Luke M" wrote:

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know the
end) and place that sum in D1.
Please help !! Urgent !!

Try this:

=SUM(D3:INDEX(D,MATCH(99^99,D)))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"itsAchint" wrote in message
news Luke,
I know I could do that but I was thinking whether we have some other options
if we don't want to sum that long.
I know we can sum a whole column using SUM(D) but you cannot place that
SUM in the same column.

"Luke M" wrote:

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know
the
end) and place that sum in D1.
Please help !! Urgent !!

Hi,

Select the numbers in column D (say in range D312) and press Ctrl+L (to
convert the range to a list). Keep the box for "My data has header rows"
unchecked if D3 is not the header row. In cell D1, enter the formula
=sum(D312). Now when you add data in D13, the sum will auto update.

This will only work with Excel 2003 and above.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"itsAchint" wrote in message
...
I want to total a column from D3 to the end of D column (I don't know the
end) and place that sum in D1.
Please help !! Urgent !!

Didn't notice you wanted to place the total in Column D.

Try this:
=SUM(D3:INDEX(D310000,MATCH(99^99,D310000)))

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"RagDyeR" wrote in message
...
Try this:

=SUM(D3:INDEX(D,MATCH(99^99,D)))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"itsAchint" wrote in message
news Luke,
I know I could do that but I was thinking whether we have some other options
if we don't want to sum that long.
I know we can sum a whole column using SUM(D) but you cannot place that
SUM in the same column.

"Luke M" wrote:

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know
the
end) and place that sum in D1.
Please help !! Urgent !!

I don't know this for sure, but my "gut" tells me that Excel will stop at
the limits of what in the VBA world is know as the UsedRange. The UsedRange
is, theoretically, the maximum range of cells in use (I said theoretically,
because deleting cell content via VB code can some times leave the UsedRange
larger than it should be). Excel tracks the extent of the cells in use and
it seems unlikely it would permit a calculation to extend into what it
"knows" is a range of cells that can have no data. So, I would simply use
=SUM(D365536) and not worry too much about it.

--
Rick (MVP - Excel)


"itsAchint" wrote in message
news
Luke,
I know I could do that but I was thinking whether we have some other
options
if we don't want to sum that long.
I know we can sum a whole column using SUM(D) but you cannot place that
SUM in the same column.

"Luke M" wrote:

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know
the
end) and place that sum in D1.
Please help !! Urgent !!

Exactly!

In other words, if the last row that contains an entry is D100, Excel
doesn't bother checking cells D10165536. So there is no difference in
efficiency between these formulas:

=SUM(D3100)
=SUM(D365536)

This does not apply to all functions/formulas, though!

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
I don't know this for sure, but my "gut" tells me that Excel will stop at
the limits of what in the VBA world is know as the UsedRange. The UsedRange
is, theoretically, the maximum range of cells in use (I said theoretically,
because deleting cell content via VB code can some times leave the
UsedRange larger than it should be). Excel tracks the extent of the cells
in use and it seems unlikely it would permit a calculation to extend into
what it "knows" is a range of cells that can have no data. So, I would
simply use =SUM(D365536) and not worry too much about it.

--
Rick (MVP - Excel)


"itsAchint" wrote in message
news
Luke,
I know I could do that but I was thinking whether we have some other
options
if we don't want to sum that long.
I know we can sum a whole column using SUM(D) but you cannot place that
SUM in the same column.

"Luke M" wrote:

Since it doesn't matter if you include blank or text cells in the SUM
function, why not:

=SUM(D365536)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"itsAchint" wrote:

I want to total a column from D3 to the end of D column (I don't know
the
end) and place that sum in D1.
Please help !! Urgent !!