CALL

The CALL function in Excel is used to execute a dynamic array formula or array of defined names and return the result.

Syntax

=CALL(function, arguments)

function A valid Excel function name or defined name to execute. It can be a single function or an array of functions.
arguments The arguments required for the function(s) specified in the 'function' parameter. These arguments can be cell references ranges constants or arrays.

About CALL

The CALL function serves as a powerful tool for dynamically executing Excel functions and named ranges, providing a flexible and efficient way to perform calculations and retrieve results. It offers the capability to handle both singular and multiple functions within an array, supporting complex data manipulation scenarios with ease and precision. By seamlessly integrating with dynamic array formulas and named ranges, CALL enhances the productivity and versatility of Excel users, streamlining the execution of diverse computations and analysis tasks. Embracing the CALL function empowers users to harness the full potential of dynamic array formulas and named ranges, unlocking a new realm of dynamic calculations and data management in Excel.

Examples

To retrieve the results of a dynamic array formula or a defined name 'SalesData', the CALL function can be used as follows: =CALL("SUM", SalesData)

For executing multiple functions within an array and obtaining the results, the CALL function can be employed in the form: =CALL({"AVERAGE", "STDEV"}, DataRange)

Questions

How does the CALL function distinguish between executing a single function and an array of functions?

The CALL function's behavior is determined by the nature of the 'function' parameter. If a single function is provided, CALL executes that specific function and returns the result. In the case of an array of functions, CALL performs the execution for each function in the array and returns an array of results, aligning with the dynamic array evaluation approach.

Can the CALL function handle multiple functions and arguments within an array?

Yes, the CALL function is designed to support the execution of multiple functions within an array, accompanied by the corresponding arguments. It seamlessly processes the array of functions and returns the array of results, efficiently accommodating complex data manipulation requirements.

Is the CALL function limited to executing only predefined Excel functions?

No, the CALL function is not restricted to predefined Excel functions. It can also execute defined names, providing the flexibility to dynamically access named ranges and retrieve their respective values or results.

Related functions

INDEX
INDIRECT
OFFSET
TRANSPOSE
FILTER
SORT
UNIQUE