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?
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?
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.