Alternative ideas:

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

=SUM(INDIRECT("D3:D"&COUNT(D3:D65536)+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: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(D3:D65536)
--
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 !!