Adding colums

[Maria from Miami]

I am having problems adding colums. I get a message "Too many arguments for
this function". What is this? How do I solve it? I only have 32 arguments.

 

[Pete_UK]

If you look at Specification in Excel Help, you will see that there is
a limit of 30 arguments in a function. However, you can do this:

=SUM(30 arguments) + SUM(2 arguments)

or this:

=SUM(29 arguments,SUM(3 arguments))

Hope this helps.

Pete

 

[Pete_UK]

I suppose I should have put:

=SUM(up_to_30_arguments) + SUM(up_to_30_arguments) etc.

or

=SUM(up_to_29_arguments),SUM(up_to_30_arguments))

Hope this helps.

Pete