Thank you very much.
When i tried to modify the cell with this formula, alert is coming, stating
there is an error in the formula. Please help.

"Don Guillett" wrote:

=SUM(Ba13:OFFSET(Ba13,MATCH(99999,Ba:Ba),1))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"prasanth" wrote in message
...
In the excel worksheet, for a column i have formula which will sum up the
values in the dynamically populated rows of the sheet.
In this scenario, i have the formula in the BA11 cell. The formula is
=SUM(BA13:BA14).

Once the excel worksheet gets populated, it's summing only up to the 1022
rows. Anyone please tell me, why its not considering the other rows? What
needs to be done to consider the other rows too? The formula displaying in
the B11 cell after the data population is =SUM($BA13:$BA1022), even if my
excel sheet has got 2683 rows.

This is an urgent production problem and the help will be appreciated.
Thanks to everyone in advance.