So I have a question regarding INDIRECT Function.Is it possible to add two indirect functions within one cell. In the attachement, F1 and F3 are constant, while G through I change depending on values in A:C. So, in F1, there is 15, but in G2, there is 225 because "F1" + " A1" = 225. While that's easy with small amount of data, I have a large amount, and what I know is their "position". I would like to use Indirect function to do what is shown in K1:M1, because I know what I want to add which is A1, so with indirect function I get the result of 210, BUT, i would like to add the F1 part, so in G1 I have 225. The same pattern falls for H1 with 575 but here there is "B1"is added to "G1" instead of "F1" as 350+ 225 = 575. The same thing with the last column. Is it possible to do it without VBA or Macro as I would prefer to excel formula instead.
Thanks
PS. I hope that the values will change respectively if I put different amounts in range " A1:C1"
Bookmarks