I have this formula in G43: =SUM(Allen:Wesley!$C24). I want to use a draggable INDIRECT formula referencing G41's value of 24. H43 value = 25, etc.
This of course does not work: =SUM(INDIRECT("Allen:Wesley!C"&H41)). Is there a way to do it using INDIRECT?