Try this:

=SUM($BV$13:OFFSET(BV14,-1,0))


"prasanth" wrote:

Hi,
I am facing a problem with the summing of the column data dynamically in the
excel worksheet.
As of now am using the sum function =SUM(BV13:BV14) for that column, but
when the rows grows dynamically, its summing only up to the 1000 rows and
ignoring the other rows.
Could anyone please tell me the solution for this?
Thanks to everyone in advance.
Regards
Prasanth