Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum function limits
I am trying to use the sum function key to add a long list of individual
subtotals (not created using the subtotal function). Example a1+a5+a13+a22 Is there a limit to the number of items I can sum? This spreadsheet has over 15 years worth of data and a complete redo to work in subtotals is prohibitive. Any help will be appreciated. Thanks Jon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum function limits
Is there a limit to the number of items I can sum?
Using that method the limit would be the length of the formula which depends on which version of Excel you're using. Excel 2007 formula length limit = 8192 characters All other versions of Excel = 1024 characters -- Biff Microsoft Excel MVP "jmcclain" wrote in message ... I am trying to use the sum function key to add a long list of individual subtotals (not created using the subtotal function). Example a1+a5+a13+a22 Is there a limit to the number of items I can sum? This spreadsheet has over 15 years worth of data and a complete redo to work in subtotals is prohibitive. Any help will be appreciated. Thanks Jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limits on lookup function? | Excel Worksheet Functions | |||
Function for upper and lower control limits? | Excel Worksheet Functions | |||
Limits | Excel Discussion (Misc queries) | |||
Limits of MINV matrix function | Excel Worksheet Functions | |||
How do i set up if function with more than level limits? | Excel Worksheet Functions |