Adding colums
 

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.
--
Thank you

Adding colums
 

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

On Dec 1, 2:23*am, Maria from Miami
wrote:
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.
--
Thank you

Adding colums
 

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

On Dec 1, 9:59*am, Pete_UK wrote:
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

On Dec 1, 2:23*am, Maria from Miami



wrote:
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.
--
Thank you- Hide quoted text -

- Show quoted text -