Autofill along a row, taking values from every second column

Dear forum members,

I have a problem which i can't solve on my own. Probably there are some answers for this already but I don't even know the appropriate keywords to search for a solution.

I want to use autofill along a row to do some basic calculations, like adding two values together. The problem is though, that I have to take values from every second column in my source sheet, like this: =C2+E2+F2+H2

how can i write this in a way so that excel does this, starting with a specified cell?

The result of the autofill should have no empty cells.


Thank you all very much!

=C2+E2+F2+H2 is not every other cell
=C2+E2+g2+i2 is every other cell

=SUMPRODUCT(--(MOD(COLUMN(C2:T2),2)=1),C2:T2) would sum every other column
but im not sure what you mean fill across
do you mean say column 1 = sum(c2) column 2 = sum(c2,e2),colum 3 =sum(c2,e2,g2) col 4 = sum(c2,e2,g2,i2) and so on?

May be something like this?

=SUMPRODUCT(1*ISODD(COLUMN(C2:H2)),C2:H2)

Hi and welcome to the forum!

Can you clarify precisely which formulas you are attempting to copy, and what you would expect the results to be?

For example, do you have the formula:

=C2

in a cell and, when copied to the right, you wish it to produce, successively:

=C2+E2
=C2+E2+F2
=C2+E2+F2+H2

etc.?

Regards

well, my case is that i have a source sheet with data like this:

<month> |##blank##| <month>
<value1a> | <value2> | <value1b> | <value2>

and on another sheet i have to use only <value1> in a calculation where i go through each month

<month> | <month> | <month> |.....
<val1a+x> |<val1b+x> | <val1c+x> |.....

it would be really tedious to specify the cells "by hand" every time, given that they are already in a certain regular order in the source. i just couldn't find a way to tell excel in which order they are

P.S.: the sum was just an example. The best thing would be if I would understand in general, how to tell excel to use the value from every second column in a formula that is then used to autofill a range of cells in a row

It will be very helpful if you attach a sample workbook to understand your data structure



Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

ok so you need in b13
=INDEX($B4:$BE4,COLUMNS($B$1:B1)*2-1) fil across and down to row 14