Count formula help

[Twizted]

this is a small portion of our job dash board that we use for our company, its a live dashboard that users within our company can update live from our different branches using onedrive and browser version of excel. this is only one tab for this location. my question is i would like to use the countif formula to count completed and incomplete but also count the blank as incomplete also, but i dont want it to count blank cell if nothing in populated in any other cell in that row. any help with this would be greatly appreciated

JOB DASH BOARD.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	CUSTOMER	LOCATION	COST CENTER	DEPARTMENT	EST #	EST DATE	PO#	PO DATE	SO#	SO DATE	WO #	WO DATE	EQUIPMENT AND JOB DESCRIPTION	LT SERVICE	NDT SERVICE	RECERT	# OF CERTS	CREW	UPLOADED / BY	JOB STATUS	INV #	INV DATE
2	SLB	LAROSE	US107194	OPEN HOLE	6352	10/7/2022	4791345989	10/14/2022	034513		WO10182201T2	10/18/2022	RS48-0055/ RC	N/A	N/A	YES	1	LAFAYETTE	YES / TL	COMPLETE
3	SLB	LAROSE	US107194	OPEN HOLE	6353	10/10/2022	4791346001	10/14/2022	034514		WO10182202T2	10/18/2022	RS48-0044/ RC	N/A	N/A	YES	1	LAFAYETTE	YES / TL	COMPLETE
4	SLB	LAROSE	US107194	OPEN HOLE	6354	10/11/2022	4791346017	10/14/2022	024703		WO10182202T1	10/18/2022	CMR-02/SLING-PUR (PO# 18045)	N/A	YES	YES	1	HOUMA		INCOMPLETE
5	SLB	LAROSE	US107206	CASED HOLE	6324	9/29/2022	4791330693	10/7/2022	034509		WO10112202T1	10/11/2022	RB-01 (PO#18034)	N/A	N/A	YES	1	HOUMA	YES/KG	COMPLETE	31760	11/3/2022
6	SLB	LAROSE	US107194	OPEN HOLE	6328	9/30/2022	4791330710	10/7/2022	027685	9/30/2022	WO10142201T1	10/14/2022	DOG HOUSE-SLING-PUR (PO#18033)	N/A	N/A	YES		HOUMA		INCOMPLETE
7	SLB	LAROSE	US107206	CASED HOLE	6314	9/28/2022	4791330629	10/7/2022	034505		WO10112204T1	10/11/2022	RAL-1111/SLING-RC	N/A	N/A	YES	1	HOUMA	YES /KG	COMPLETE	31759	11/3/2022
8					6314		4791330629	10/7/2022	034505		WO10142203F	10/14/2022	RAL-1111/NDT	N/A	YES	N/A	1	HOUMA	YES/CG	COMPLETE	31759	11/3/2022
9	SLB	LAROSE	US107206	CASED HOLE	6322	9/29/2022	4791330702	10/7/2022	034508		WO10132202T1	10/13/2022	RB-11/SLING-PUR	N/A	N/A	YES	1	HOUMA		COMPLETE
10					6322	9/29/2022	4791330702	10/7/2022	034508		???	???	RB-11/NDT	N/A	YES	N/A		HOUMA
11	SLB	LAROSE	US107206	CASED HOLE	6336	10/4/2022	4791330822	10/6/2022	034512		WO10142202F	10/14/2022	NI-10/NDT	N/A	YES	N/A	1	HOUMA	YES/CG	INCOMPLETE
12	SLB	LAROSE	US107194	OPEN HOLE	6330	10/3/2022	4791330772	10/6/2022	024700		WO10052206T1	10/5/2022	GOL-1104/SLING-RC	N/A	N/A	YES	1	HOUMA		INCOMPLETE	31780	11/3/2022
13	SLB	LAROSE	US107206	CASED HOLE	6355	10/11/2022	4791346075	10/13/2022	024707				11003, 5086, 5092, 5098	N/A	YES	YES		HOUMA		INCOMPLETE
14	SLB	LAROSE	US107194	OPEN HOLE	6357	10/11/2022	4791346102	10/14/2022	024706		WO10242201LT	10/24/2022	HBL-1103/LT/NDT	YES	YES	N/A		HOUMA		INCOMPLETE
15	SLB	LAROSE	US107194	OPEN HOLE	6357		4791346102	10/14/2022	024706		WO10252201F	10/25/2022	HBL-1103 HOSE BOX					HOUMA
16	SLB	LAROSE	US107206	CASED HOLE	6358	10/11/2022	4791346089	10/14/2022	024705		WO10212202F	10/21/2022	LT-02/NDT	N/A	YES	YES		HOUMA		INCOMPLETE
17					6358	10/11/2022	4791346089	10/14/2022	024705		WO10182201T1	10/18/2022	LT-02/NEW SLING(PO# 18044)					HOUMA
18	SLB	LAROSE	US100843		6340		4791343858	10/12/2022	024702		WO10052206F	10/5/2022	WI-TB15002		YES		1	HOUMA		INCOMPLETE	31758	11/3/2022
19	SLB	LAROSE	US107194	MISC	6318	9/29/2022	4791318548	10/3/2022	024696		WO10052201LT	10/5/2022	4659-19( DOG HOUSE)	YES	N/A	N/A	1	LAFAYETTE		INCOMPLETE	31779	11/3/2022
20	SLB				6318		4791318548	10/3/2022	024696		WO10052205F	10/5/2022	4659-19( DOG HOUSE)	N/A	YES	N/A	1	HOUMA
21	SLB	LAROSE	US107206	CASED HOLE			4791311621		034501		WO10032201T2	10/3/2022	(2) 26" G2 WTI SHEAVES	N/A	N/A	YES	2	LAFAYETTE	YES / TL	COMPLETE
22	SLB	LAROSE	US107160	ES08	6291	9/27/2022	4791322785	9/27/2022	024684		WO10072202T1	10/7/2022	FBIL-1109	N/A	N/A	YES	1	HOUMA	YES/CG	COMPLETE	31753	11/3/2022
23	SLB	LAROSE	US107206	CASED HOLE	6298	9/27/2022	4791322646	9/27/2022	024685		WO10062201F	10/6/2022	CBX-06	N/A	YES	N/A	1	HOUMA		INCOMPLETE	31755	11/3/2022
24	SLB	LAROSE	US107206	CASED HOLE	6299	9/27/2022	4791322615	9/27/2022	024686		WO10072201F	10/7/2022	BFWBB-1	N/A	YES	N/A		HOUMA		INCOMPLETE
25	SLB	LAROSE	US107194	MISC	6300	9/27/2022	4791322672	9/27/2022	024687		WO10042206T1	10/4/2022	TDL-HT-1052	N/A	N/A	YES	1	HOUMA		INCOMPLETE	31777	11/3/2022
26	SLB	LAROSE	US107206	CASED HOLE	6303	9/27/2022	4791322698	10/3/2022	024691		WO10052203T1	10/5/2022	BFWWBB-1	N/A	N/A	YES	1	HOUMA		INCOMPLETE	31763	11/3/2022
27	SLB	LAROSE	US107206	CASED HOLE	6364	10/12/2022	4791370090	10/24/2022	024708		WO10172201T1	10/17/2022	HST-027014-125/BLP-266819 SHACKLES,HST-037964-001	N/A	YES	YES		HOUMA		INCOMPLETE
28	SLB	LAROSE	US107194	OPEN HOLE	6365	10/12/2022	4791370095	10/26/2022	024704		WO10262203T1	10/26/2022	GOL-1302, NEW SLING(PO# 18055)	YES	YES	YES		HOUMA		INCOMPLETE
29	SLB	LAROSE	US107206	GUNSHOP	6319	9/29/2022	4791318429	10/3/2022	034504		WO10052202LT	10/5/2022	GBA-03	YES	YES	N/A	2	LAFAYETTE		INCOMPLETE	31762	11/3/2022
30	SLB				6319	9/29/2022	4791318429	10/3/2022	034504		WO10112203T1	10/11/2022	GBA-03	N/A	N/A	YES	1	HOUMA		INCOMPLETE	31762	11/3/2022
31	SLB	LAROSE	US107206	GUNSHOP	6309	9/28/2022	4791343865	10/14/2022	034503		WO10052203LT	10/5/2022	CBX-02 (FAILED NDT )	N/A	YES	N/A	0	LAFAYETTE	N/A	COMPLETE
32					6309	9/28/2022	4791343865	10/14/2022	034503		???	???	CBX-02 (LT/NDT)	YES	YES	N/A				TBD
33					6309	9/28/2022	4791343865	10/14/2022	034503		WO10182205T1	10/18/2022	CBX-02 (SLING PO# 18048)	N/A	N/A	YES		HOUMA		TBD
34	SLB	LAROSE	US107194	OPEN HOLE	6339	10/4/2022	4791343836	10/14/2022	024701		WO10062202T1	10/6/2022	BLP-273111-075,10236, 1039, BLP-09286-005, 1457 LOT C6, 5388	N/A	N/A	YES	7	HOUMA		COMPLETE	31761	11/3/2022
35	SLB	LAROSE	US100843	SLICKLINE	5010	7/26/2021	4790653018	7/27/2021	291098				WI-TB15003	N/A	YES	YES		HOUMA
36	SLB	LAROSE	US107194	OPEN HOLE	5104	8/25/2021	4790674145	9/12/2021	051942				RADIATION PIT COVER BOTTOM	N/A	YES	YES		HOUMA
37	SLB	LAROSE	US107194	OPEN HOLE	5241	10/13/2021	4790715648	10/14/2021	454416				FBL-D1703	N/A	YES	N/A		HOUMA
38	SLB	LAROSE	US107194	OPEN HOLE	6325	9/29/2022	4791330705	10/6/2022	024699		WO10122205F	10/12/2022	VMP-NG 1012	N/A	N/A	YES	1	HOUMA	YES / CG	COMPLETE
39	SLB	LAROSE	US107194	OPEN HOLE	6305	9/28/2022	4791322792	10/4/2022	024690		WO10072201T1	10/7/2022	TPL-1303	N/A	N/A	YES	1	HOUMA	YES / CG	COMPLETE	31756	11/3/2022
2022 LAROSE

 

[jasonb75]

but i dont want it to count blank cell if nothing in populated in any other cell in that row.

Is there a specific column that would always be filled in first?

22 columns of data means a lot of cross counting if you want to check every one of them.

 

[Twizted]

Is there a specific column that would always be filled in first?

22 columns of data means a lot of cross counting if you want to check every one of them.

all our jobs start with a SO # so i would say if yes start with looking in I Column

 

[jasonb75]

Using column I as a control for the blanks, this formula should do as you need.

=SUM(COUNTIFS(I:I,"<>",T:T,{"","INCOMPLETE"}))

 

[Twizted]

Using column I as a control for the blanks, this formula should do as you need.

=SUM(COUNTIFS(I:I,"<>",T:T,{"","INCOMPLETE"}))

thanks that is doing the job

 

[smozgur]

thanks that is doing the job

The marked solution post has been switched accordingly.

@Twizted: In your future question, that would be great if you could mark the post as the solution that answered the question to help future readers. No action is required for this thread.