I have two identical tables on a sheet: one that contains text for reference, and a second that contains values.
I am trying to sum up some cells in the second table but using the addresses of cells in the first table to do so.
For example, if this is my data:
B1 contains apple B11 contains 0.5 B5 contains egg B15 contains 1.5 C7 contains ham C17 contains 0.5
is there a way I can write a formula
=SUM(B1,B5,C7) but increment the row number of the arguments by 10 using some function?