Need Formula for desired Increment in cell reference number instead of 1

[jd16]

Hello Everyone,


PFA of Excel sheet for my queries.



Thanks In Advance.

[RaulSerg]

Can you explain your logic of the right results, I cannot follow.

[jd16]

Can you explain your logic of the right results, I cannot follow.

Thanks RaulSerg for a very promp reply.
you can see cell N2 formula for understand the concept better then my explanation,
still let me try in brief, if "*" value will be between a2:d2, result should come as "*" else it should show B2+D2 value, now if we drag same formula to right then it should take cell references from c2:f2 for check * value instead of b2:e2, and if logical test false then it should show value of d2+f2.

[PKowalik]

@RaulSerg, the logic seems to be
8+1 = 9 (0 between 8 and 1 skipped)
1+6 = 7 (0 between 1 and 6 skipped)
6+0 = 6 (4 between 6 and 0 skipped and so on)
3+3 = 6
6+6 = 12
6+9 = 15
9+7 = 16
7+4 = 11

For the first group of formulas type e.g. in Z1
=IFERROR(INDEX($A2:$L2,1,COLUMN(A1)*2)+INDEX($A2:$L2,1,COLUMN(A1)*2+2),"*")
and drag and drop 4 columns right and 1 row down.

[jd16]

@RaulSerg, the logic seems to be
8+1 = 9 (0 between 8 and 1 skipped)
1+6 = 7 (0 between 1 and 6 skipped)
6+0 = 6 (4 between 6 and 0 skipped and so on)
3+3 = 6
6+6 = 12
6+9 = 15
9+7 = 16
7+4 = 11

For the first group of formulas type e.g. in Z1
=IFERROR(INDEX($A2:$L2,1,COLUMN(A1)*2)+INDEX($A2:$L2,1,COLUMN(A1)*2+2),"*")
and drag and drop 4 columns right and 1 row down.

Exactly !
Thanks a ton PKowalik for saving my lots of time.


Warm Regards

[PKowalik]

You're welcome. Do you need a formula for vertical copying in column N, too?

PS. Edit your post #5 and remove the quotation of my post #4. Personally, I don't care but such quotations are not welcome on this forum.