Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula using several colums | Excel Worksheet Functions | |||
Global Macro Adding rows or colums to many Excel files at the same | Excel Discussion (Misc queries) | |||
Linked colums and more | Charts and Charting in Excel | |||
Colums | Charts and Charting in Excel | |||
Sum YTD Colums | Excel Discussion (Misc queries) |