Problem with entering a value in a "SUM" formula

[Mel2013]

Hi everyone,

I hope I can get some advice on this....
I'm entering a formula that requires the sum of values from a number of different sheets. The last item (number 31 in the string of values) is unable to be entered successfully in the formula. I'm getting the message that "more arguments have been specified for this function than are allowed in the current file format". If I remove this last item, the formula works, but of course my total is incorrect without this value having been included. Also the Excel version that the workbook is formatted in is 1997-2003. I'm not the greatest Excel user so I'm not sure if there is a way to work around this. Please help!

[Motu040602]

use a different cell to sum a few of your arguments...then use that cell in your long formula to get the total you need.

[FDibbins]

If you are just dealing with single cell ranges, skip the SUM() and just add them...=sheet1!A1+sheet1!d4+sheet2!a3....etc

Another option would be to break your SUM() down into a few different SUM()'s. Maybe something like this, by sheet....
=sum(sheet1!A1,sheet1!d3)+sum(sheet2!a3,sheet2!........................

[Mel2013]

Another option would be to break your SUM() down into a few different SUM()'s. Maybe something like this, by sheet....
=sum(sheet1!A1,sheet1!d3)+sum(sheet2!a3,sheet2!........................[/QUOTE]

Thanks so much for the help guys! I opted to use the resolution as quoted above.....quick and easy fix.