Hello Everyone,
PFA of Excel sheet for my queries.
Thanks In Advance.
Hello Everyone,
PFA of Excel sheet for my queries.
Thanks In Advance.
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.
@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.
Last edited by PKowalik; 06-16-2020 at 10:39 AM.
Przemyslaw Kowalik, Lublin Univ. of Technology
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks