Hallo,
I would simply like to sum G2:G(x).
I want to make use of a formula to calculate what x should be and have actually developed the following two ways:
=ADDRESS(MATCH(F1,A1:A337,0)+11,7,4)
="G"&MATCH(F1,A1:A337,0)+11
So x will obviously differ, depending on what F1 is. My problem is that when you substitute any of these formulas in the SUM equation, it doesn't work.
Can anyone please help?
Thanks!
I would simply like to sum G2:G(x).
I want to make use of a formula to calculate what x should be and have actually developed the following two ways:
=ADDRESS(MATCH(F1,A1:A337,0)+11,7,4)
="G"&MATCH(F1,A1:A337,0)+11
So x will obviously differ, depending on what F1 is. My problem is that when you substitute any of these formulas in the SUM equation, it doesn't work.
Can anyone please help?
Thanks!