Eric has nailed the point about having the formula in the header so it won’t interfere with your second row.
If you want to read more about arrayformula then I had a post here.
Eric has nailed the point about having the formula in the header so it won’t interfere with your second row.
If you want to read more about arrayformula then I had a post here.