| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
