Hi, i have created multiple dynamic ranges using the offset function and these ranges are working fine; for instance, range1, range , range 3, etc... All these ranges contain numbers.
If i do a sum(range1) i do get the proper sum of values contained in range1. However, instead of calling directly the range in the sum function as previously mentioned i need to call it from a cell, see below for clarity:
So the first two lines are working fine but somehow i cannot refer to a working range via a cell content... Is there a workaround ?
Thanks.
If i do a sum(range1) i do get the proper sum of values contained in range1. However, instead of calling directly the range in the sum function as previously mentioned i need to call it from a cell, see below for clarity:
So the first two lines are working fine but somehow i cannot refer to a working range via a cell content... Is there a workaround ?
Thanks.