#CALC!
the calculation engine cannot produce the requested array.
what it means
The formula is valid but asks for something the array engine cannot represent — most often an empty array, or an array nested inside another array.
common causes
- a filter that matched nothing and has no fallback
- a formula that would produce an array of arrays
- an array operation the engine does not support
how to fix it
- give the filter an if-empty argument
- flatten the calculation so it returns one array, not nested ones
- compute the intermediate step in its own cell