The autofill option is repeating every cell twice...

[theo_c]

Hello again

I have written on worksheet 2 in cell D4 the following function: =SUMIF(MarchSales!B2:Q2, "Cash", MarchSales!B3:Q3)

In the cell just under it, D5 I have written the following function: =SUMIF(MarchSales!B4:Q4, "Cash", MarchSales!B5:Q5)

Then I select both cells, and drag it down for the auto fill option to fill the rest of the empty cells, but the result isn't as expected

After the autofill has been done, in cell D6 the following appears: =SUMIF(MarchSales!B4:Q4, "Cash", MarchSales!B5:Q5)

And in Cell D7: =SUMIF(MarchSales!B6:Q6, "Cash", MarchSales!B7:Q7)

And in cell D8: =SUMIF(MarchSales!B6:Q6, "Cash", MarchSales!B7:Q7)

And in cell D9: =SUMIF(MarchSales!B8:Q8, "Cash", MarchSales!B9:Q9)

So in conclusion, the autofill option is repeating every function twice... Is there anyway to make it follow the logic of the first 2 cells (D4 and D5)?

Thanks again

[Jonmo1]

yeah, you can't fill formulas down while incrimenting references by 2 rows.

You need some range manipulation with Index and Rows..

Try this in D4 and filled down
=SUMIF(INDEX(MarchSales!B:Q,(ROWS(A$1:A1)-1)*2+2,0), "Cash", INDEX(MarchSales!B:Q,(ROWS(A$1:A1)-1)*2+3,0))

Don't change the A$1:A1, it has no relation to your data.
The *2 is the interval (every 2 rows)
The +2 (and +3) is the row# to begin with.

[theo_c]

Now that was complicated, but worked perfectly!!! Even successfully used it on other Worksheets and adjusted the +2 and +3 to +69 and +70... Thanks again Jonmo1 you've helped me greatly today

[Jonmo1]

Great, glad it helped.