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]
