I would need an example to see what you mean. How does the formula bar claim it's working?

Also take into account that some functions create arrays to calculate a single answer (SUMPRODUCT or COLUMNS), but return an array which can only be seen by selecting a range before entering the formula as you did ( see the INDEX(range,,#) syntax)

Perhaps this introduction to array formulas will shed some more light on the matter

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post