Reference Input Excel Multiple Regression

Hello everyone,

I am currently having issues doing a multiple regression in Excel, the only issue I have is that the independent variable (X) columns are not next to each other. For example, in the "Data" -> "Data Analysis" -> "Regression" screen:

Input Y range: $B$150:$B$174
Input X range: $D$150:$F$174

This will yield a satisfactory result, the regression is successful without errors.

However, in my case the X columns are not next to each other, so I have to alter the input in the "Regression" screen:

Input Y range: $B$150:$B$174
Input X range: $D$150:$D$174+$E$150:$E$174+$F$150:$F$174

When I use this reference, Excel claims "the reference you typed is not valid...".

What is the correct way to refer to X variables in a regression in Excel which are not next to each other in a table?

Hello m1e. Welcome to the forum.

In order to get a clearer ideal of what you are working with it is almost always beneficial to upload a small sample workbook that clearly exemplifies both what you are working with and what you expect the outputs to be.
See the instructions in the 'gold' banner at the top of this page. HOW TO ATTACH YOUR SAMPLE WORKBOOK: