Sum Function
 

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.

Sum Function
 

=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.

Sum Function
 

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.

Sum Function
 

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" 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.

Sum Function
 

Bitte

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"prasanth" wrote in message
...
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" 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.