Help! I've been trying for hours to get this formula to work and at a loss. I need to get a sum from a range of numbers in Column F on a tab named "R3A". I know the starting cell is always "R3A!F4" but the end of the range will change each month. I'm calculating the end of the range and it's stored in cell C23.
So, i'm using this formula:
=SUM(INDIRECT("'R3A'!F4:'R3A'!F"&C23))
The results is #REF!
What am i doing wrong?
So, i'm using this formula:
=SUM(INDIRECT("'R3A'!F4:'R3A'!F"&C23))
The results is #REF!
What am i doing wrong?
