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