Thread: Adding colums
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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 -