LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Dynamic summation of column

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use dynamic column reference without R1C1 Pontificateur Excel Worksheet Functions 3 February 4th 08 10:55 PM
Summation of a filtered column DavidS New Users to Excel 3 September 27th 06 04:54 PM
Dynamic column insert (macro) Chris Excel Discussion (Misc queries) 2 March 15th 06 11:33 AM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill ers Charts and Charting in Excel 0 March 1st 06 01:05 AM
trying to find the smallest with dynamic column changes Andy Excel Discussion (Misc queries) 1 February 24th 06 09:07 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"