Maybe I'm missing something obvious here but won't (A1+B1+C1) + (D1+E1) + ...
work? On Mon, Jul 21, 2008 at 5:58 PM, Anthony Andrews <[EMAIL PROTECTED]> wrote: > 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]
