Regression analysis

[SineYlo]

Hello!
Can't figure out how to do discontinuous regression analysis.
I enter the formula ($ D$2:$D$16;$F$2:$G$16) into the input interval X, and he writes to me: "The interval must be a reference to a contiguous region."
I just need to exclude one center block from the regression analysis.
It works only with such a formula ($D$2:$G$16), but it is necessary that such an area be selected, as described above.
How to do it?

[#2]

I would suggest to create a separate area that serves as the input of your regression. In that area you only include the data you want to use for the regression.

[#3]

I totally agree with @Jan Karel Pieterse  suggestion.

But if you just don't want to create a new area you could try something like (Office365):

FILTER($D$2:$G$16;COLUMN($D$2:$G$16)<>5)

which is just like creating a new area, but virtually