Sum Function

[prasanth]

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 it’s 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.

 

[Don Guillett]

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

 

[prasanth]

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.

 

[prasanth]

Thank you very much.
Its working when i changed the comma with ";". It may be due to am using the
german keyboard.

Is it a limitation of the excel to sum only 1022 rows, if we give
=Sum(BA13:BA14)

 

[Don Guillett]

Bitte