Excel imposes the 30 argument limit. Having read Peter's reply, that seems the most logical and simple IMO. It bypasses the SUM() function entirely and would do the same job (kicks himself for not thinking of it!!).
--- On Mon, 7/21/08, Chris Gamble <[EMAIL PROTECTED]> wrote: From: Chris Gamble <[EMAIL PROTECTED]> Subject: Re: SUM Exceeding 30 Columns To: "POI Users List" <[email protected]> Date: Monday, July 21, 2008, 9:46 AM Thanks, will try. Is this a limitation in POI or excel. I just did 50 arguments in Open Office and no error. Dont have excel.. Anthony Andrews wrote: > Ignore that, will not work!!! > > The other thought that sprang to mind was could you use intermediate cells to hold running totals for you so to speak? So, in one cell you would enter a sum() formula to calculate the total of a number of cells, in another a second sum() formula to calculate the total of another series of cells and in a third cell a sum() formula to simply add together the calculated products of these two intermediate cells. I would guess that you could even use a an additional sheet to hold these intermediate cewlls if necessary. > > --- On Mon, 7/21/08, Anthony Andrews <[EMAIL PROTECTED]> wrote: > From: Anthony Andrews <[EMAIL PROTECTED]> > Subject: Re: SUM Exceeding 30 Columns > To: "POI Users List" <[email protected]> > Date: Monday, July 21, 2008, 8:58 AM > > Do not know if it will work in your application but have you looked at the > SUMPRODUCT() function? This can be used to calculate the totals of a number of > arrays or ranges but it is again limited to the 30 argument maximum. > > Further, have you tried using brackets to 'fool' the SUM() finction? > Again, I do not know if it would work but you could try; > > SUM((A1 + B1 + C1), (D1 + E1), (F1 + G1)) etc....... > > Have not tried this so I expect Excel will simply swear at you but it would be > easy enough to test. > > --- On Mon, 7/21/08, Chris Gamble <[EMAIL PROTECTED]> wrote: > From: Chris Gamble <[EMAIL PROTECTED]> > Subject: SUM Exceeding 30 Columns > To: [email protected] > Date: Monday, July 21, 2008, 8:25 AM > > Just ran into an error yesterday telling me that the sum function can > only support 30 arguments. I am trying to calculate the Grand Total of > several sub totals, so doing this as a range is not effective. Does > anyone know a work around for this? > > thanks > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
