adding cells based on day of the week

[jbrown021286]

hours log.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		date	notes	RO	status	SUM	Daignosis	CODE	JOB	FLAG TIME	ADJUSTMENT	Column1
3		4/8/2024		6208383		5.4	micu keyless reciver and battery				5.4		don’t count	Waiting	incorect
4		4/8/2024		6208727			door glass						0	0	0			Check List
5		4/8/2024		6208927		2.0	rotors				2		Total	Not Verifyed	Verifyed			0.0
6		4/8/2024		6208927		0.2		cf	cabin filter	0.2			12.6	12.6	0
7		4/8/2024		6208927		5.0	timing cover resaeal				5
8													Day	Hours	Average
9													Monday
10													Tuesday
11													Wednesday
12													Thursday
13													Friday
14													Saturday
15
16
17
18
LOG

Cell Formulas
Range	Formula
I3:I18	I3	=IF(H3="","",INDEX($X$3:$X$91,MATCH(H3,$W$3:$W$91,0),1))
J3:J18	J3	=IF(I3="","",INDEX($Y$3:$Y$91,MATCH(H3,$W$3:$W$91,0),1))
M4	M4	=SUMIF(E:E,"N",F:F)+SUMIF(E:E,"cnf",F:F)
N4	N4	=SUMIF(E:E,"w",F:F)
O4	O4	=SUMIF(E:E,"x",F:F)
R5	R5	=SUM(U:U)
M6	M6	=SUM(F:F,)-SUMIF(E:E,"N",F:F)-SUMIF(E:E,"nf",F:F)-N2
N6	N6	=SUMIF(E:E,"",F:F)+SUMIF(E:E,"c",F:F)
O6	O6	=SUMIF(E:E,"G",F:F)-N2
B3:B18	B3	=IF([@RO]<>"",IF(B3="",TODAY(),B3),"")
F3:F18	F3	=SUMIF(Table111[@[FLAG TIME]:[ADJUSTMENT]],"<>",Table111[@[FLAG TIME]:[ADJUSTMENT]])

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N36,N83,D3:D280,K22:K52	Expression	=COUNTIF(T:T,D3)>0	text	NO
B3	Expression	=" =COUNTIFS(D:D,A1,E:E,J2)>0"	text	NO
A2	Expression	=" =COUNTIFS(D:D,A1,E:E,J2)>0"	text	NO
E3:E280	Cell Value	=$M$39	text	NO
G5:G7	Cell Value	=$M$38	text	NO
G5:G7	Cell Value	=$M$37	text	NO
G5:G7	Cell Value	=$M$36	text	NO
G5:G7	Cell Value	=$M$35	text	NO
G5:G7	Cell Value	=$M$34	text	NO
G5:G7	Cell Value	=$M$33	text	NO
E3:E280	Cell Value	=$M$38	text	NO
E3:F280	Cell Value	=$M$37	text	NO
E3:F280	Cell Value	=$M$36	text	NO
E3:F280	Cell Value	=$M$35	text	NO
E3:F280	Cell Value	=$M$34	text	NO
E3:F280	Cell Value	=$M$33	text	NO
F3:F280	Expression	=" =COUNTIFS(D:D,A1,E:E,J2)>0"	text	NO
K3:L5,U3:U280,L6:L7	Expression	=COUNTIFS(XEX:XEX,J3,XEZ:XEZ,K3)>0	text	NO
F3:F280	Expression	=COUNTIFS(T:T,D3,U:U,F3)>0	text	NO
A2	Expression	=COUNTIFS(K:K,XEY3,#REF!,A2)>0	text	NO
B3	Expression	=COUNTIFS(K:K,XEY4,#REF!,B3)>0	text	NO

i am wanting to add column F based on the day of the week in column B if the date is a Monday i want to have the sum in cell N9 if it is Tuesday N10 and so on. is there a good way of achieving this?

 

[Asbestos_Jen]

Your formulas mostly produced errors in my sheet, so I pasted the cells as values and worked from that. I added a helper column to the table next to the date to show weekdays and used that in the countif in cells N9:N14. I'm not sure what your average formula entails, so I didn't put anything there.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2		date	Weekday	notes	RO	status	SUM	Daignosis	CODE	JOB	FLAG TIME	ADJUSTMENT	Column1
3		08-04-24	Monday		6208383		5.4	micu keyless reciver and battery				5.4		don’t count	Waiting	incorect
4		08-04-24	Monday		6208727		0	door glass						0	0	0
5		09-04-24	Tuesday		6208927		2	rotors				2		Total	Not Verifyed	Verifyed
6		09-04-24	Tuesday		6208927		0.2		cf	cabin filter	0.2			12.6	12.6	0
7		10-04-24	Wednesday		6208927		5	timing cover resaeal				5
8		10-04-24	Wednesday				0							Day	Hours	Average
9		11-04-24	Thursday				0							Monday	5.4
10		11-04-24	Thursday				0							Tuesday	2.2
11		12-04-24	Friday				0							Wednesday	5
12		12-04-24	Friday				0							Thursday	0
13		13-04-24	Saturday				0							Friday	0
14		13-04-24	Saturday				0							Saturday	0
15		14-04-24	Sunday				0
16		14-04-24	Sunday				0
17		15-04-24	Monday				0
18		15-04-24	Monday				0
Sheet1

Cell Formulas
Range	Formula
O9:O14	O9	=SUMIF(Sheet1!$C$3:$C$18,N9,Sheet1!$G$3:$G$18)
C3:C18	C3	=TEXT(WEEKDAY(Sheet1!$B3),"Dddd")