IF statement that will change by 2 instead of 1 when I drag it down

[still learning]

Hi

Can I write an IF statement that will change by 2 instead of 1 when I drag it down?

=IF(B5=”x”,+C5,””)

I want the next line to be

=IF(B7=”x”,+C7,””)

Then the next line

=IF(B9=”x”,+C9,””)

All the way down to B45
If I copy the B5 statement down, it changes the B cell by 1. I need it to change by 2

The only way I know is to drag the first down, then delete every other line, then move the lines I didn’t delete up


mike

 

[Fluff]

How about

=IF(INDEX(B:B,ROWS(M$3:M3)*2+3)="X",INDEX(C:C,ROWS(M$3:M3)*2+3),"")

 

[still learning]

Hi Fluff,
Is M the column where the if statement goes?
I don't have time now, but I' try it this evening
I m trying to eliminate every other line to make it look nice. Now i have blank lines
B is where the "x" goes, C is a number
B is also where a "y" goes,
the if statement separates the two and gives a running total
the if statement starts in AC5 for "x" and
Ai5 for "y"
or course the x and y are longer words.
the data actually goes from B to G, but I thought if I had one statement correct, I can just change the letter
B is always "x" or "y", C,D,E,F,G is always numbers.

 

[Fluff]

Just change the M$3:M3 to reflect the first cell the formula is in.

 

[still learning]

Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.