should this formula work

[jbrown021286]

i am looking to make a formula that references a worksheet labeled aggregated data and i am wanting to add all the numbers in row 4 column c-ag if the date in the corresponding cells on row 3 are between the start of the week and today with the week starting on Sunday. this is the formula i have. any ideas on how to make it work. =SUMIFS('Aggregated Data'!C4:AG4,'Aggregated Data'!C3:AG3,".="&Date(year(Today()),Day(Today())-Weekday(Today(),1)+1),'Aggregated Data'!C3:AG3,"<="&Today())

 

[awoohaw]

Try this:
(I used a testing day date instead of the TODAY() function, since today is Day 7 and all records would be selected.)
Also, i am unsure if you wanted consecutive dates in Row3, these are random, but the formula will work either way.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1
2
3	Testing Day		Wed 2024/01/10	Fri 2024/01/12	Thu 2024/01/04	Sun 2024/01/07	Fri 2024/01/12	Sun 2024/01/07	Tue 2024/01/02	Tue 2024/01/02	Mon 2024/01/08	Sun 2024/01/07	Sat 2024/01/13	Fri 2024/01/05	Tue 2024/01/02	Mon 2024/01/08	Fri 2024/01/05	Tue 2024/01/09	Fri 2024/01/05	Thu 2024/01/04	Sat 2024/01/13	Mon 2024/01/15	Tue 2024/01/09	Wed 2024/01/10	Sat 2024/01/13	Mon 2024/01/01	Tue 2024/01/09	Mon 2024/01/08	Wed 2024/01/10	Thu 2024/01/11	Mon 2024/01/01	Tue 2024/01/09	Tue 2024/01/09
4	2024-02-13		6	2	7	4	4	2	4	4	9	8	3	5	9	8	3	6	2	8	7	9	5	9	6	4	6	9	8	2	7	4	2
5
6			100
Sheet5

Cell Formulas
Range	Formula
C6	C6	=SUM((WEEKDAY($C$3:$AG$3,1)<=WEEKDAY(A4,1))*($C$4:$AG$4))

 

[jbrown021286]

TECH HOURS WORKSHEET 2.0 tester.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Tech Hours
2			01FEB24	02FEB24	03FEB24	04FEB24	05FEB24	06FEB24	07FEB24	08FEB24	09FEB24	10FEB24	11FEB24	12FEB24	13FEB24	14FEB24	15FEB24	16FEB24	17FEB24	18FEB24	19FEB24	20FEB24	21FEB24	22FEB24
3			1-Feb	2-Feb	3-Feb	4-Feb	5-Feb	6-Feb	7-Feb	8-Feb	9-Feb	10-Feb	11-Feb	12-Feb	13-Feb	14-Feb	15-Feb	16-Feb	17-Feb	18-Feb	19-Feb	20-Feb	21-Feb	22-Feb
4	Jeff	101502	1.1	9.9	22.5		8.4	22.0	14.2	0.3	17.5	13.9		7.4	8.0	4.6	4.8
5	Justin	101549	2.0	20.0	4.0		6.5	10.4	5.2	5.2	3.0	13.8
6	Ramy	103642	11.2	6.2	3.5			15.1	5.0	9.4	11.6	9.5		1.4	15.8	11.0	9.6
7	Tuzzo	107132	7.1	7.4	8.9		10.5	3.5	3.9	11.2	3.9	5.0		2.3	2.8	8.8	8.0
8	Brandun	107471		8.3	8.8		8.2	0.2						6.6	2.1	11.1
9	Carl	107801	2.6					7.4	2.8	4.2	0.3	40.0		2.0	7.7	9.9	3.0
10	Rod Jones	108228	3.8	3.4	3.0			5.1	1.9	2.5	4.6	0.5				0.8	2.5
11	Que	108243	4.0	0.3	4.1		7.5	3.3	4.9	4.4	1.3	5.6		4.6	6.6	2.1	5.4
12	James	108410	4.6	6.5	10.1		7.1	6.9	2.6	4.9	5.9	6.3		10.2	0.5	7.2	10.8
13	Owens	108634	2.2	18.8	3.3				8.0	21.3	20.8			6.4		8.1	6.3
14	Hawk	109543	9.6	9.0	15.2		5.5	3.7	17.4	6.5	1.0	8.1		7.4	5.1	12.9	8.3
15	Josh	109572	9.2	11.8				9.3	9.5	11.5	7.3	14.1		1.0	12.4	13.2	6.0
16	David	109783	5.6	4.2	4.8		0.5			3.8	7.0	6.2		1.0			3.3
17	Angel	109930	10.8	3.6	1.0					6.1	14.1	11.2		9.7	1.1	6.9	8.6
18	Immanuel	1021024	3.5	3.3	4.6		5.8	5.2	2.9	-0.2	3.6	4.8		6.1	6.7	2.0
19	Jamie	1021025	3.1	2.9	2.1			1.7	2.2	3.2	2.6	3.8		0.3	4.9	1.7	3.6
20	Peter	1021026	1.3	2.0	2.6		3.9		0.5					3.4		5.2
21	Frederick	1021027	9.4	7.4	7.1		9.8	11.1		1.2	12.6	6.8		0.7	4.7		12.0
22	Jerusha	1021028	2.8	2.3	1.0		2.3	1.4	1.9	3.9		3.8		3.4	1.6		1.4
23	Gerrardo	1021029		3.3	2.9		4.1	2.4	2.9		3.4	7.2		4.9	3.8	1.9
24	Tre	1021032	4.3	3.4	4.0			1.8	3.8	2.4	6.1	3.1		0.3	5.0	3.4	2.2
25	Harry	1021037	0.5	2.5	0.9		1.9		3.2	3.3	3.5	3.2		2.2		3.1	1.0
26	Contrer	1021038			1.5		0.8	1.0	1.4	1.9
27	Trevin	1021039	2.1	2.2	2.2		1.1	2.7		2.7	2.6	2.9		2.2	3.7		2.8
28	Venro	1021040	0.5	5.5	14.6			9.0	4.2	5.1	2.6	4.1		13.8		2.2	10.5
29	Blank	Blank
30	Blank	Blank
Aggregated Data

Cell Formulas
Range	Formula
C4:C30	C4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,'Aggregated Data'!B4,RTH!$B:$B,$C$2)
D4:D30	D4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,$D$2)
E4:E30	E4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,$E$2)
F4:F30	F4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,$F$2)
G4:G30	G4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,$G$2)
H4:H30	H4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,H$2)
I4:I30	I4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,I$2)
J4:J30	J4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,J$2)
K4:K30	K4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,K$2)
L4:L30	L4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,L$2)
M4:M30	M4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,M$2)
N4:N30	N4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,N$2)
O4:O30	O4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,O$2)
P4:P30	P4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,P$2)
Q4:Q30	Q4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,Q$2)
R4:R30	R4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,R$2)
S4:S30	S4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,S$2)
T4:T30	T4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,T$2)
U4:U30	U4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,U$2)
V4:V30	V4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,V$2)
W4:W30	W4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,W$2)
X4:X30	X4	=SUMIFS(RTH!$N:$N,RTH!$E:$E,B4,RTH!$B:$B,X$2)

this is the sheet that i am referencing

TECH HOURS WORKSHEET 2.0 tester.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	2/17/2024
2
3										Week to Date
4
5
6			101502	101549	103642	107132	107471	107801	108228	108243	108410	108634	109543	109572	109783	109930	1021024	1021025	1021026	1021027	1021028	1021029	1021032	1021037	1021038	1021039	1021040
7			Jeff	Justin	Ramy	Tuzzo	Brandun	Carl	Rod Jones	Que	James	Owens	Hawk	Josh	David	Angel	Immanuel	Jamie	Peter	Frederick	Jerusha	Gerrardo	Tre	Harry	Contrer	Trevin	Venro
8		hours	134.6
9
10
Hours

Cell Formulas
Range	Formula
A1	A1	=TODAY()
C8	C8	=SUM((WEEKDAY('Aggregated Data'!C3:AG3,1)<=WEEKDAY(A1,1))*('Aggregated Data'!C4:AG4))

and this is the sheet i am wanting the output in. for some reason it is totaling the entire row for me not just the current week

 

[awoohaw]

Well, you're formula is results in every day in the range C3:AG3 being selected. You are asking for a weekday function which with option 1 is a Sunday to Monday week, with Sunday being 1 and Saturday being 7. Today (Feb 17) is a Saturday. So every value in the expression Weekday(C2:AG3,1) is a number 1 thru 7, and your comparing it to Weekday(Saturday Feb 17, 2024,1) which resolves to 7. So you have all TRUES and all data on row C4:AG4 will be returned to the SUM() function.
And, as I see in you mini worksheet you posted (thank you for doing that!) you have a heading called "Week To Date". So, you really needed a different approach, your OP says Days since Sunday, not Days Since Sunday of the target date (which is Today() so the current week).

And I cannot replicate your Aggregate Data values because you have formulas on that worksheet that refer to a sheet called RTH or something. So, I'll use dummy data.
Also, I could not use all of your names, it made the file too big to past as an xl2bb.
You'll notice I have a validation conditional formatting, and only two rows are green that is because I only summed the 7 days (2/11 thru 2/18) to get compare to the new calculation, and both of those are using 2/17/2024 as the date. After 2/17, the first row that is using the TODAY() function will return a date in a new week begining tomorrow.

I hope I have covered the question.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Today:	Sat 2024-02-17
2
3			Jeff	Justin	Ramy	Tuzzo	Brandun	Carl	Rod Jones	Que	James	Owens
4			101502	101549	103642	107132	107471	107801	108228	108243	108410	108634
5	Using TODAY() in Cell B1: >>>		36.80	68.00	61.90	41.10	57.50	45.00	65.80	39.80	76.80	46.90
6	Testing Date:	Pior Sunday
7	Thu 2024-02-08	Sun 2024-02-04	30.00	45.60	35.90	52.40	38.00	34.40	39.30	58.50	54.00	28.20
8	Fri 2024-02-09	Sun 2024-02-04	30.40	51.90	48.70	62.40	44.40	40.20	54.60	58.50	54.60	34.50
9	Sat 2024-02-10	Sun 2024-02-04	35.30	60.90	53.60	65.10	48.50	51.70	62.30	73.90	68.70	39.20
10	Sun 2024-02-11	Sun 2024-02-11	11.30	15.50	2.00	13.10	6.40	10.30	11.60	11.00	15.10	8.50
11	Mon 2024-02-12	Sun 2024-02-11	21.10	27.40	6.50	15.00	20.10	21.70	20.80	11.00	29.00	22.00
12	Tue 2024-02-13	Sun 2024-02-11	22.50	34.80	21.70	16.20	28.40	21.70	29.70	24.50	40.70	22.60
13	Wed 2024-02-14	Sun 2024-02-11	23.20	38.30	29.40	30.30	32.70	30.30	41.30	32.10	53.60	25.20
14	Thu 2024-02-15	Sun 2024-02-11	27.80	39.60	44.40	31.70	40.10	37.70	49.30	32.10	64.20	33.80
15	Fri 2024-02-16	Sun 2024-02-11	34.90	53.00	49.90	37.70	43.70	38.10	52.00	36.50	69.70	44.90
16	Sat 2024-02-17	Sun 2024-02-11	36.80	68.00	61.90	41.10	57.50	45.00	65.80	39.80	76.80	46.90
17	Sun 2024-02-18	Sun 2024-02-18	4.60	10.50	3.80	7.00	11.20	0.00	3.40	12.50	0.90	9.30
18	Mon 2024-02-19	Sun 2024-02-18	13.90	21.20	5.80	10.00	22.00	9.60	5.30	13.30	15.40	22.00
19	Tue 2024-02-20	Sun 2024-02-18	23.10	22.30	19.90	24.80	22.50	24.40	6.00	29.00	31.20	33.70
20	Wed 2024-02-21	Sun 2024-02-18	27.90	25.00	31.00	33.70	36.70	25.10	18.90	37.50	45.30	42.30
21
22
23	Tech Hours
24			Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday		W/B 2/11 To Date
25			2024-02-01	2024-02-02	2024-02-03	2024-02-04	2024-02-05	2024-02-06	2024-02-07	2024-02-08	2024-02-09	2024-02-10	2024-02-11	2024-02-12	2024-02-13	2024-02-14	2024-02-15	2024-02-16	2024-02-17	2024-02-18	2024-02-19	2024-02-20	2024-02-21	2024-02-22
26	Jeff	101502	9.3	1	14.5	12.1	2	1.4	2.4	12.1	0.4	4.9	11.3	9.8	1.4	0.7	4.6	7.1	1.9	4.6	9.3	9.2	4.8	13.7		36.8
27	Justin	101549	9.5	2.1	15	11.5	3.8	11.5	8	10.8	6.3	9	15.5	11.9	7.4	3.5	1.3	13.4	15	10.5	10.7	1.1	2.7	8.7		68
28	Ramy	103642	8.3	0.5	6.5	2.1	0.4	5.3	13.3	14.8	12.8	4.9	2	4.5	15.2	7.7	15	5.5	12	3.8	2	14.1	11.1	13		61.9
29	Tuzzo	107132	10.7	1.4	15.6	5	15.2	15.4	11.5	5.3	10	2.7	13.1	1.9	1.2	14.1	1.4	6	3.4	7	3	14.8	8.9	11.8		41.1
30	Brandun	107471					8.8	8.6	10.8	9.8	6.4	4.1	6.4	13.7	8.3	4.3	7.4	3.6	13.8	11.2	10.8	0.5	14.2	11.2		57.5
31	Carl	107801					15.8	11.5		7.1	5.8	11.5	10.3	11.4		8.6	7.4	0.4	6.9		9.6	14.8	0.7	1.2		45
32	Rod Jones	108228					15.7	5.5	6.7	11.4	15.3	7.7	11.6	9.2	8.9	11.6	8	2.7	13.8	3.4	1.9	0.7	12.9	6.5		65.8
33	Que	108243	1.4	7.6	7.6	15.4	3.5	15.8	11.6	12.2		15.4	11		13.5	7.6		4.4	3.3	12.5	0.8	15.7	8.5	1.7		39.8
34	James	108410	12.1	12.9	8.1	15.4	15.2		10.9	12.5	0.6	14.1	15.1	13.9	11.7	12.9	10.6	5.5	7.1	0.9	14.5	15.8	14.1	7.2		76.8
35	Owens	108634	10.5				9.5	9.8	7.5	1.4	6.3	4.7	8.5	13.5	0.6	2.6	8.6	11.1	2	9.3	12.7	11.7	8.6	11		46.9
Aggregated Data

Cell Formulas
Range	Formula
B1	B1	=TODAY()
C3:L4	C3	=TRANSPOSE(A26:B35)
C5:L5	C5	=SUM( ($B$1>=$C$25:$X$25)* (WORKDAY.INTL($B$1+1,-1,"1111110")<=$C$25:$X$25)* ($B$26:$B$35=C$4)* ($C$26:$X$35))
B7:B20	B7	=WORKDAY.INTL($A7+1,-1,"1111110")
C7:L20	C7	=SUM( ($A7>=$C$25:$X$25)* (WORKDAY.INTL($A7+1,-1,"1111110")<=$C$25:$X$25)* ($B$26:$B$35=C$4)* ($C$26:$X$35))
A8:A20	A8	=A7+1
Z26:Z35	Z26	=SUM(M26:S26)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C5:L20	Expression	=XLOOKUP(C$4,$B$26:$B$35,$Z$26:$Z$35,0)<>C5	text	NO
C5:L20	Expression	=XLOOKUP(C$4,$B$26:$B$35,$Z$26:$Z$35,0)=C5	text	NO