Using the results of a formula as part of a new formula

[xcl1997]

Is there a way to turn C4 into a formula that actually performs a sum range of the result produced by the formula that's already in the cell? Referencing C4 in a sum range from another cell works (for example, [SUM(INDIRECT(C4))] in C5 produces the correct value of "0"). But is there a way to do it all within the same cell?

9-16-22 MrExcel.xlsx
	C	D	E	F	G	H	I	J	K	L
4	'Daily Tally'!G7702:G7722	'Daily Tally'!H7702:H7722	'Daily Tally'!I7702:I7722	'Daily Tally'!J7702:J7722	'Daily Tally'!K7702:K7722	'Daily Tally'!L7702:L7722	'Daily Tally'!M7702:M7722	'Daily Tally'!N7702:N7722	'Daily Tally'!O7702:O7722	'Daily Tally'!P7702:P7722
5	0	0	0	0	0	0	0	0	0	2.25
Sheet1

Cell Formulas
Range	Formula
C4:HR4	C4	="'Daily Tally'!"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B389,'Daily Tally'!A:A,0)&":"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B389+1,'Daily Tally'!A:A,0)-1
C5:L5	C5	=SUM(INDIRECT(C4))
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
DailyTallyData	='Daily Tally'!$A$5:$D$6644	C4

 

[xcl1997]

In that case I would suggest you stick with your original solution.

Fine. You don't want to help, then don't. But you had a suggestion for me, I have one for you - if you're really here to help people, rather than imply they give up on their goal, you should brush up on your spreadsheet skills instead.

 

[Fluff]

I would suggest that you learn a little patience, I was only on site for a very brief period yesterday & did not have a chance to review this further.
Also maybe you are the one who needs to "brush up on your spreadsheet skills" as you are the one asking for help.

 

[xcl1997]

I would suggest that you learn a little patience, I was only on site for a very brief period yesterday & did not have a chance to review this further.
Also maybe you are the one who needs to "brush up on your spreadsheet skills" as you are the one asking for help.

Exactly, I'm asking for your help. But you're not helping when you get frustrated because you can't resolve a problem I present, and then imply I also give up on the problem.

 

[Fluff]

I am not frustrated in any way, but sometimes it is better to use an old style formula that needs to be dragged, rather than horrendous complex formula that will spill.

 

[xcl1997]

I am not frustrated in any way, but sometimes it is better to use an old style formula that needs to be dragged, rather than horrendous complex formula that will spill.

True. Just wanted to see if it could be done.