Help with SumIFs - Auto updating formula with new client name

[WoodisGood]

Good morning fellow Excellers!


This spreadsheet is used as a task breakdown of our designer - what client he works (Client), which category and for how long. He is not Excel savvy so I am trying to make this as easy as possible. The client names can change every week. Currently, I have taught him how to edit the SumIF formula to work for each client name. He has to edit each formula to update the client name as needed per week. What I am trying to figure out is how to write the formula so "Corle" would not have to be manually updated in each formula.

Current Formula - =SUMIFS(M:M,K:K,"Corle",L:L,"prelim")

Cell P3 is named as "Client1"
How can I have the SumIF formula reference the text in Cell P3 (Corle) so each formula will update to whatever text in is in cell P3?

What I need the formula to read as "=SUMIFS(M:M,K:K,"P3",L:L,"prelim")

Any help would be super appreciated. I have 3 separate Excel books and cannot seem to find the answer I need.

1-3 To 1-14-22.xlsx
	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Date	Client Name	Category	Time (hours)	Notes
2	1/3	Lizzio	Revisions	1.00				Total Prelim Hours	Total Software Hours	Total Layout Hours	Total Presentation Hours	Total Drive Time Hours	Total Rendering Hours	Total Revision Hours	Total In House Hours	Total Project Hours
3	1/3	CypherTek	Software	2.00	New computer/Network setup		Corle	18.5	0	0	0	0	5.5	14	0	38
4	1/3	Corle	Prelim	4.00			Lizzio	0	0	0	0	0	0	6	0	6
5	1/3	Corle	Rendering	1.00			HTF	0	0	0	0	0	0	0	15	15
6	1/4	Corle	Prelim	4.00			Lodge	13	0	0	0	0	2	0	0	15
7	1/4	Lizzio	Revisions	4.00			FNG Train	0	4.5	0	0	0	0	0	0	4.5
8	1/5	Corle	Prelim	5.00			CypherTek	0	2	0	0	0	0	0	0	2
Sheet1

Cell Formulas
Range	Formula
Q3	Q3	=SUMIFS(M:M,K:K,"Corle",L:L,"prelim")
R3	R3	=SUMIFS(M:M,K:K,"Corle",L:L,"software")
S3	S3	=SUMIFS(M:M,K:K,"Corle",L:L,"Layout")
T3	T3	=SUMIFS(M:M,K:K,"Corle",L:L,"presentation")
U3	U3	=SUMIFS(M:M,K:K,"Corle",L:L,"Drive Time")
V3	V3	=SUMIFS(M:M,K:K,"Corle",L:L,"Rendering")
W3	W3	=SUMIFS(M:M,K:K,"Corle",L:L,"Revisions")
X3	X3	=SUMIFS(M:M,K:K,"Corle",L:L,"In House")
Y3:Y8	Y3	=SUM(Q3:X3)
Q4	Q4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"prelim")
R4	R4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"software")
S4	S4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"layout")
T4	T4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"presentation")
U4	U4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"Drive Time")
V4	V4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"Rendering")
W4	W4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"Revisions")
X4	X4	=SUMIFS(M:M,K:K,"Lizzio",L:L,"In House")
Q5	Q5	=SUMIFS(M:M,K:K,"HTF",L:L,"prelim")
R5	R5	=SUMIFS(M:M,K:K,"HTF",L:L,"software")
S5	S5	=SUMIFS(M:M,K:K,"HTF",L:L,"layout")
T5	T5	=SUMIFS(M:M,K:K,"HTF",L:L,"presentation")
U5	U5	=SUMIFS(M:M,K:K,"HTF",L:L,"Drive Time")
V5	V5	=SUMIFS(M:M,K:K,"HTF",L:L,"Rendering")
W5	W5	=SUMIFS(M:M,K:K,"HTF",L:L,"Revisions")
X5	X5	=SUMIFS(M:M,K:K,"HTF",L:L,"In House")
Q6	Q6	=SUMIFS(M:M,K:K,"Lodge",L:L,"prelim")
R6	R6	=SUMIFS(M:M,K:K,"Lodge",L:L,"software")
S6	S6	=SUMIFS(M:M,K:K,"Lodge",L:L,"layout")
T6	T6	=SUMIFS(M:M,K:K,"Lodge",L:L,"presentation")
U6	U6	=SUMIFS(M:M,K:K,"Lodge",L:L,"Drive Time")
V6	V6	=SUMIFS(M:M,K:K,"Lodge",L:L,"Rendering")
W6	W6	=SUMIFS(M:M,K:K,"Lodge",L:L,"Revisions")
X6	X6	=SUMIFS(M:M,K:K,"Lodge",L:L,"In House")
Q7	Q7	=SUMIFS(M:M,K:K,"FNG FNG Train",L:L,"prelim")
R7	R7	=SUMIFS(M:M,K:K,"FNG Train",L:L,"software")
S7	S7	=SUMIFS(M:M,K:K,"FNG Train",L:L,"layout")
T7	T7	=SUMIFS(M:M,K:K,"FNG U7Train",L:L,"presentation")
U7	U7	=SUMIFS(M:M,K:K,"FNG Train",L:L,"Drive Time")
V7	V7	=SUMIFS(M:M,K:K,"FNG FNG Train",L:L,"Rendering")
W7	W7	=SUMIFS(M:M,K:K,"FNG Train",L:L,"Revisions")
X7	X7	=SUMIFS(M:M,K:K,"FNG Train",L:L,"In House")
Q8	Q8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"prelim")
R8	R8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"software")
S8	S8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"layout")
T8	T8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"presentation")
U8	U8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"Drive Time")
V8	V8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"Rendering")
W8	W8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"Revisions")
X8	X8	=SUMIFS(M:M,K:K,"CypherTek",L:L,"In House")

Cells with Data Validation
Cell	Allow	Criteria
L2:L8	List	=$Q$31:$Q$38

 

[Fluff]

Hi & welcome to MrExcel.
Just remove the quotes from around "P3", otherwise it treats that as a text string, rather than a cell reference.

 

[WoodisGood]

Hi & welcome to MrExcel.
Just remove the quotes from around "P3", otherwise it treats that as a text string, rather than a cell reference.

Thank you SO very much! I have been trying to figure this out for 2 days. My coworker would also like to thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.