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

 

[Fluff]

Maybe

=SUM(INDIRECT("'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))

 

[xcl1997]

Maybe

=SUM(INDIRECT("'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))

Not familiar with the "CODE=xls" part, and Excel won't let me enter it in a cell. But I tried the formula in between the CODE parts - it gave a value of "1", but the value should be "0". Also, it did not spill into other parts of row 4 as desired.

 

[xcl1997]

Not familiar with the "CODE=xls" part, and Excel won't let me enter it in a cell. But I tried the formula in between the CODE parts - it gave a value of "1", but the value should be "0". Also, it did not spill into other parts of row 4 as desired.

Never mind my mention about the "CODE" part. I see that is just part of the code of the thread.

 

[Fluff]

In that case can you post some sample data from the Daily Tally sheet.

 

[xcl1997]

In that case can you post some sample data from the Daily Tally sheet.

The first sample is a repost of Sheet1. To make things easier, the formula in question is now in C1. The second sample is from the Daily Tally sheet.

Spreadsheet A - (for upwork) Daily Diet Starting From 8-29-2021.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
1		'DAILY TALLY'!G5:G22	'DAILY TALLY'!H5:H22	'DAILY TALLY'!I5:I22	'DAILY TALLY'!J5:J22	'DAILY TALLY'!K5:K22	'DAILY TALLY'!L5:L22	'DAILY TALLY'!M5:M22	'DAILY TALLY'!N5:N22	'DAILY TALLY'!O5:O22	'DAILY TALLY'!P5:P22	'DAILY TALLY'!Q5:Q22	'DAILY TALLY'!R5:R22
2	Daily average	0.01	0.00	0.01	0.00	0.00	0.01	0.01	0.01	0.02	0.06	0.01	0.11
3		2x Chicken Burrito, white rice, pinto beans, hot salsa, lettuce; Chipotle	2x Chicken Burrito, white rice, pinto beans, mild salsa, lettuce; Chipotle	2x Pollo Asado Burrito, guac, white rice, pinto beans, hot salsa, lettuce; Chipotle	2x Pollo Asado Burrito, white rice, pinto beans, hot salsa, lettuce; Chipotle	3 Musketeers Fun Size Bars (30g)	85% Cacao, classic blackout, organic dark chocolate, (4 sections=30g); alter eco	86% Cacao, intense dark, dark chocolate, (3 pieces=34g); Ghirardelli	all purpose unbleached flour, organic, 1/4 cup (30g); simply balanced	Almond milk, unsweetened, organic; 365	Almond milk, unsweetened, vanilla, organic; 365	Almondmilk, organic, unsweetened, organic; Orgain	Almondmilk, vanilla, unsweetened; Almond Breeze
4
5
6
7
8	8/28/2021	sum: 2.00	1.00	3.00	1.00	0.30	2.67	2.62	4.18	6.33	22.30	4.26	42.78
9	8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.19
10	8/30/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.19
Sheet1

Cell Formulas
Range	Formula
B1	B1	=IF(AND(SUM(INDIRECT(SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+1,4),"1","")&ROWS($A$1:$A$8)&":"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+1,4),"1","")&ROWS($A$1:$A$8)))=0,COLUMNS(INDIRECT("C3:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+2,4),"1","")&ROWS(A$1:A$3)))=FoodListUnitsCount),"NEED TO ADD SERVING FIELD FOR FOOD IN LAST COLUMN!!","")
C2:N2	D2	=SUM(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMNS($A$1:D1),4),"1","")&"9:"&SUBSTITUTE(ADDRESS(1,COLUMNS($A$1:D1),4),"1","")&Sheet1lstrow))/ROWS(INDIRECT("$B$9:$b$"&Sheet1lstrow))
C1:HR1	C1	="'DAILY TALLY'!"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B9,'Daily Tally'!A:A,0)&":"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B9+1,'Daily Tally'!A:A,0)-1
C3:HR3	C3	=TRANSPOSE(SORT(INDIRECT("'Food List & Units'!B2:B"&FoodListUnitsCount),1))
C8	C8	=CONCATENATE("sum: "&TEXT(SUM(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMN(C9),4),"1","")&ROWS($C$1:$C9)&":"&SUBSTITUTE(ADDRESS(1,COLUMN(C9),4),"1","")&Sheet1lstrow))," 0.00"))
D8:N8	D8	=SUM(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMN(D9),4),"1","")&ROWS($C$1:$C9)&":"&SUBSTITUTE(ADDRESS(1,COLUMN(D9),4),"1","")&Sheet1lstrow))
B9:B10	B9	=B8+1
C9:N10	C9	=IF($B9=MAX(INDIRECT("'Daily Tally'!A1:A"&DailyTallylstrwofsprdsht)),SUM(INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&XMATCH($B9,INDIRECT("'Daily Tally'!$A$1:$A"&DailyTallylstrwofsprdsht),0)):INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&DailyTallylstrwofsprdsht)),IF($B9<MAX(INDIRECT("'Daily Tally'!A1:A"&DailyTallylstrwofsprdsht)),SUM(INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&XMATCH($B9,INDIRECT("'Daily Tally'!$A$1:$A"&DailyTallylstrwofsprdsht),0)):INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&XMATCH($B9+1,INDIRECT("'Daily Tally'!$A$1:$A"&DailyTallylstrwofsprdsht),0)-1))))
Dynamic array formulas.

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

Spreadsheet A - (for upwork) Daily Diet Starting From 8-29-2021.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2		Symbol	Units				2x Chicken Burrito, white rice, pinto beans, hot salsa, lettuce; Chipotle	2x Chicken Burrito, white rice, pinto beans, mild salsa, lettuce; Chipotle	2x Pollo Asado Burrito, guac, white rice, pinto beans, hot salsa, lettuce; Chipotle	2x Pollo Asado Burrito, white rice, pinto beans, hot salsa, lettuce; Chipotle	3 Musketeers Fun Size Bars (30g)	85% Cacao, classic blackout, organic dark chocolate, (4 sections=30g); alter eco	86% Cacao, intense dark, dark chocolate, (3 pieces=34g); Ghirardelli	all purpose unbleached flour, organic, 1/4 cup (30g); simply balanced	Almond milk, unsweetened, organic; 365	Almond milk, unsweetened, vanilla, organic; 365	Almondmilk, organic, unsweetened, organic; Orgain	Almondmilk, vanilla, unsweetened; Almond Breeze
3
4
5	8/29/2021	ptcj	33	Premium Tortilla Chips, jalapeno cheddar, (20 chips=28g); Old Dutch Restaurant Style	COPY FROM HERE BELOW (ROW 6)!	8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
6		pdc8	12	Pure Dark Chocolate, 85% dark chocolate, 1/2 bar;4 squares=42g; theo Organic Fair Trade		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
7		stpb	17	Spicy Thai Peanut Butter, (1 tbsp=14g); Eliot's		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
8		oq&c	60	Organic Quinoa & Chia Seeds Supercereal, (1oz=28g); Awsum Snacks		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
9		avua	1.5	Almondmilk, vanilla, unsweetened; Almond Breeze		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.19
10		s-coo	40	Steel-Cut Oats, organic, (1/4 cup=40g); 365		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
11		kscm	0.0937	Kosher Salt, coarse; Morton		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
12		kscm	0.0625	Kosher Salt, coarse; Morton		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
13		ctst	0.5	Chickpea Taco Salad... - TB12 Purple Carrot (low sug/salt/no avoc,oil, or dress/.5 tofu)		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
14		dsem	1	Dietary Supplement, every man's One Daily Multi; New Chapter		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
15		acrw	0.367	Avocados, California, raw, whole, peeled, average-size (4.8 oz without seed)		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
16		pcgo	70	Polenta, Corn Grits, organic, (1/4 cup=46g); Bob's Red Mill		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
17		mbd&	8	Medium Buffalo Dipping & Wing Sauce, (1 Tbsp=15g); Noble Made		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
18		jsh1	1	Jalapeno, sliced, hot, (12 slices=28g); Mrs. Renfro's		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
19		wbps	129	Water, bottled (Poland Spring)		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
20		tcbt1	0.5	Tandoori Chickpea Burgers - TB12 Purple Carrot (NO OIL/low fat/sod/sug)		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
21		aocp	0.67	Avocado Oil, cold pressed, naturally refined, (1 Tbsp = 14g); Choosen Foods		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
22		sgfc	112	Spaghetti, gluten free, corn & rice, (56g=2oz); 365		8/29/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
23	8/30/2021	avua	1.50	Almondmilk, vanilla, unsweetened; Almond Breeze		8/30/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.19
24		cfrs	1.00	Cajun Fries, regular size; Popeye's		8/30/2021	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Daily Tally

Cell Formulas
Range	Formula
G2:HV2	G2	=TRANSPOSE(SORT(INDIRECT("'Food List & Units'!B2:B"&FoodListUnitsCount),1))
D5:D7744	D5	=VLOOKUP(FILTER(INDIRECT("B5:B"&DailyTallylstrwofsprdsht),1),INDIRECT("'Food List & Units'!A2:B"&FoodListUnitsCount),2,0)
F5:F24	F5	=IF(AND(A4<>"",A5="",A6="",B6<>""),F4,IF(AND(A4="",A5<>"",A6="",B6<>""),A5,IF(AND(A4="",A5="",A6="",B6<>""),F4,IF(AND(A4="",A5="",A6<>"",B6<>""),F3,IF(AND(A4="",A5="",A6="",B6="",B5=""),"",IF(AND(A4="",A5="",A6="",B6="",B5<>""),F4+1))))))
G5:HV24	G5	=IF(TRANSPOSE(SORT(INDIRECT("'Food List & Units'!B2:B"&FoodListUnitsCount),1))=D5,C5/FILTER(INDIRECT("'Food List & Units'!C2:C"&FoodListUnitsCount),'Daily Tally'!B5=INDIRECT("'Food List & Units'!A2:A"&FoodListUnitsCount)),0)
E6:E24	E6	=IF(AND(B6<>"",SUM(INDIRECT("G"&ROWS(E$1:E6)&":"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS(E$1:E6)))=0),"need to add food","")
Dynamic array formulas.

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

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
JI1:JM1,A1:F1,J1:FH1,FJ1:HU1,IX1:IZ1,JP1:JQ1,KQ1:XFD1,HW1:IN1	Cell Value	duplicates	text	NO

 

[Fluff]

There is so much going on in there & you are looking at other sheets, so I have no way to test this, but you could try

=BYCOL("'DAILY TALLY'!"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B9,'Daily Tally'!A:A,0)&":"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B9+1,'Daily Tally'!A:A,0)-1,LAMBDA(bc,SUM(INDIRECT(bc))))

 

[xcl1997]

There is so much going on in there & you are looking at other sheets, so I have no way to test this, but you could try

=BYCOL("'DAILY TALLY'!"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B9,'Daily Tally'!A:A,0)&":"&SUBSTITUTE(ADDRESS(1,MATCH(SORT('Daily Tally'!G2#),C3:HV3,0)+6,4),"1","")&XMATCH(B9+1,'Daily Tally'!A:A,0)-1,LAMBDA(bc,SUM(INDIRECT(bc))))

Plugging your formula into C4, the array shows the correct value in fk4, but incorrect values for all other non-zero cells. For reference, row 9 is the correct totals for each food for that date. Tried different dates in place of b9 in the formula, and it shows the formula is only giving non-zero values for the first food that shows up on the date in column D of the Daily Tally sheet.

Spreadsheet A - (for upwork) Daily Diet Starting From 8-29-2021.xlsx
	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK
1	'DAILY TALLY'!FB5:FB22	'DAILY TALLY'!FC5:FC22	'DAILY TALLY'!FD5:FD22	'DAILY TALLY'!FE5:FE22	'DAILY TALLY'!FF5:FF22	'DAILY TALLY'!FG5:FG22	'DAILY TALLY'!FH5:FH22	'DAILY TALLY'!FI5:FI22	'DAILY TALLY'!FJ5:FJ22	'DAILY TALLY'!FK5:FK22	'DAILY TALLY'!FL5:FL22	'DAILY TALLY'!FM5:FM22	'DAILY TALLY'!FN5:FN22	'DAILY TALLY'!FO5:FO22
2	0.21	0.01	0.02	0.02	0.02	0.01	0.57	0.01	0.01	0.00	1.25	0.02	0.01	0.13
3	Pineapple chunks, organic, (1 cup=140g); 365	Pineapple, raw, slices, average (3-1/2" diameter x 3/4" thick, 3.0 oz)	Pizza, pepperoni & sausage, 1/4 of 19.4oz pizza (138g); Tombstone	Pizza, The Works, original-crust, medium, (1 slice); Papa John's	Pizza, The Works, original-crust, small, (1 slice); Papa John's	Pizza, vegan supreme, 1/3 pizza (132g); Amy's	Plant Calcium, Bone Strength, Take Care, Tiny Tabs; New Chapter	Plant-Based chick'n noodl', (1 can=425g); gardein	Plant-Based Hamburger Helper Meal, Deluxe Cheeseburger Macaroni	Plant-Based minestrone & saus'ge, (1 can=425g); gardein	Polenta, Corn Grits, organic, (1/4 cup=46g); Bob's Red Mill	Popcorn, cheese, 2.25 cups (28g); Old Dutch	Potato Chips, dill pickle, (57g) 2 oz bag; Old Dutch	Premium Tortilla Chips, jalapeno cheddar, (20 chips=28g); Old Dutch Restaurant Style
4	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1.18
5	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1.18
6
7
8	78.32	3.67	8.00	8.00	6.00	2.83	219.00	2.00	2.00	1.00	478.91	5.93	2.00	49.35
9	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1.52	0.00	0.00	1.18
Sheet1

Cell Formulas
Range	Formula
EX2:FK2	EX2	=SUM(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMNS($A$1:EX1),4),"1","")&"9:"&SUBSTITUTE(ADDRESS(1,COLUMNS($A$1:EX1),4),"1","")&Sheet1lstrow))/ROWS(INDIRECT("$B$9:$b$"&Sheet1lstrow))
EX8:FK8	EX8	=SUM(INDIRECT(SUBSTITUTE(ADDRESS(1,COLUMN(EX9),4),"1","")&ROWS($C$1:$C9)&":"&SUBSTITUTE(ADDRESS(1,COLUMN(EX9),4),"1","")&Sheet1lstrow))
EX9:FK9	EX9	=IF($B9=MAX(INDIRECT("'Daily Tally'!A1:A"&DailyTallylstrwofsprdsht)),SUM(INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(EX$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&XMATCH($B9,INDIRECT("'Daily Tally'!$A$1:$A"&DailyTallylstrwofsprdsht),0)):INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(EX$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&DailyTallylstrwofsprdsht)),IF($B9<MAX(INDIRECT("'Daily Tally'!A1:A"&DailyTallylstrwofsprdsht)),SUM(INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(EX$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&XMATCH($B9,INDIRECT("'Daily Tally'!$A$1:$A"&DailyTallylstrwofsprdsht),0)):INDIRECT("'daily tally'!"&SUBSTITUTE(ADDRESS(1,XMATCH(EX$3,INDIRECT("'Daily Tally'!A2:"&SUBSTITUTE(ADDRESS(1,FoodListUnitsCount+5,4),"1","")&ROWS($A$1:$A$2)),0),4),"1","")&XMATCH($B9+1,INDIRECT("'Daily Tally'!$A$1:$A"&DailyTallylstrwofsprdsht),0)-1))))

 

[Fluff]

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

 

[xcl1997]

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

Aw, come on. It's probably just an adjustment or two away from being correct. Will you give it one more shot?