Formula Assistance

Question

Hello, Microsoft Community!&nbsp;I am in need of formula help once again. I want to COUNT the number of entries in two separate columns (A and C) but only if they meet certain criteria in a third column (B).&nbsp;Q: What is the total number of services provided to those who speak English AND what is the total number of services provided to those who speak Spanish? The sum total of services equals 20.&nbsp;&nbsp;Example:&nbsp;ABCDEFServices ALanguageServices BColumn3&nbsp;&nbsp;CSEng&nbsp;---CSEng&nbsp;---MAEng&nbsp;---MAEng&nbsp;---MAEng&nbsp;---MAEng&nbsp;---PNEng&nbsp;---PNEng&nbsp;---PNEng&nbsp;-&nbsp;&nbsp;PTEngA-POC&nbsp;EngB-AC-MASp&nbsp;---MASp&nbsp;---MASp&nbsp;---MASp&nbsp;---PCSp&nbsp;-&nbsp;&nbsp;PCSp&nbsp;-&nbsp;&nbsp;PCSp&nbsp;-&nbsp;&nbsp;&nbsp;SpC&nbsp;--&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Services:20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Eng:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Sp:&nbsp;&nbsp;Thank you for helping me with the project with skills beyond my abilities.

detlef_lewin · Accepted Answer

MMHiggins&nbsp;For "Eng":=COUNTIFS(B2:B20,"Eng",A2:A20,"&lt;&gt;")+COUNTIFS(B2:B20,"Eng",C2:C20,"&lt;&gt;")

Forum Discussion

Formula Assistance

2 Replies

A	B	C	D	E	F
Services A	Language	Services B	Column3
CS	Eng		-	-	-
CS	Eng		-	-	-
MA	Eng		-	-	-
MA	Eng		-	-	-
MA	Eng		-	-	-
MA	Eng		-	-	-
PN	Eng		-	-	-
PN	Eng		-	-	-
PN	Eng		-
PT	Eng	A	-	PO	C
	Eng	B	-	AC	-
MA	Sp		-	-	-
MA	Sp		-	-	-
MA	Sp		-	-	-
MA	Sp		-	-	-
PC	Sp		-
PC	Sp		-
PC	Sp		-
	Sp	C		-	-

				Total Services:	20

				Total Eng:
				Total Sp: