# Is there a maximal number of arguments for functions [closed]

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to conduct a simple MEAN function with reference to 75 cells. The problem ist that it only takes reference to the first 30. The 31th and the following are not taken into calculation of the mean. Does anybody know if there is a maximal number of arguments that the function can take reference to?

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-20 20:55:21.287559

Sort by » oldest newest most voted

There is no MEAN function in the standard list. So I am assuming you mean the AVERAGE function.

Most function can take 30 individual arguments or a range (e.g. A1:B500). To find out how many arguments are accepted goto Help-Functions or enter the function wizard (fx left of the input line), select your function and click next, then it shows you the max. number of arguments.

more

Do you mean "user-defined function" (macro) or "native" function of Calc? I have just an experiment - function

=AVERAGE(A1;A2;A3;A4;A5;A6;...<skip some (244) addresses>...;A251;A252;A253;A254)


gives the correct result. Longer formula (more than 1171 characters) are not placed in the cell. But I know that any long formula can be written shortly. For example, in this case

=AVERAGE(A1:A254)


Perhaps, your formula can be simplified and written short too?

more