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]
