I need to pass in two strings indicating the two locations of the range. However, SUM wouldn't read the string, but it reads the value of what's supposed to be the indicator of a location.
What I wrote:
=SUM(E20:E21)
The value of E20
is E4
, and the value of E21
is E10
. They are both dynamically generated. How can I get the actual sum from the location that the value of E20
indicates to the location that the value of E21
indicates?
INDIRECT