Counting Occurrences

[alm395]

I have a table with employees down column A and dates going across (3/20/20 - 4/4/21). Each date is tracked with that person's daily status. I already have a section that counts the totals (number of days) of each status type, but am now looking to find the number of times/occurrences each person has taken a specific status code. I needing help with the formula for column V. This will be done across multiple tabs in one workbook that is tracking approximately 1100 employees, if that makes any difference.

Example:
Status Code "Out Of Office"
PERSON 1: Total Days=6 / # Occurrences=2
PERSON 3: Total Days=1 / # Occurrences=1
PERSON 6: Total Days=12 / # Occurrences=3
PERSON 8: Total Days=5 / # Occurrences=4

Any help is appreciated because I have not been able to figure this out. Thank you in advance!

Min Max Avg Days.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1																					Out of Office
2	Full Name	12/28/2020	12/29/2020	12/30/2020	12/31/2020	1/1/2021	1/2/2021	1/3/2021	1/4/2021	1/5/2021	1/6/2021	1/7/2021	1/8/2021	1/9/2021	1/10/2021	1/11/2021	1/12/2021	1/13/2021	1/14/2021	1/15/2021	TOTAL DAYS	# OCCUR
3	PERSON 1	Active	Out Of Office	Active	Active	Active	Day Off	Day Off	Active	Active	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Active	Active	Active	Active	Active	6	2
4	PERSON 2	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Active	Active	Day Off	Day Off	Out Of Office	Out Of Office	Active	Active	Active	2	1
5	PERSON 3	Active	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Day Off	Day Off	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Out Of Office	Active	5	2
6	PERSON 4	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Active	Active	0	0
7	PERSON 5	Out Of Office	Out Of Office	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Active	Active	Out Of Office	Out Of Office	Out Of Office	9	3
8	PERSON 6	Active	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Out Of Office	Active	Active	Active	Out Of Office	Out Of Office	Out Of Office	Active	Active	Active	Out Of Office	Out Of Office	12	3
9	PERSON 7	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Active	Active	0	0
10	PERSON 8	Active	Active	Out Of Office	Active	Out Of Office	Day Off	Day Off	Out Of Office	Active	Out Of Office	Out Of Office	Active	Day Off	Day Off	Active	Active	Active	Active	Active	5	4
11	PERSON 9	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Active	Active	Active	Active	Day Off	Day Off	Active	Out Of Office	Out Of Office	Active	Active	2	1
Sheet1

Cell Formulas
Range	Formula
U3:U11	U3	=COUNTIF(B3:T3,$U$1)

 

[Tetra201]

Try

=COUNTIFS(B3:T3,$U$1,C3:U3,"<>"&$U$1)

 

[alm395]

Try

=COUNTIFS(B3:T3,$U$1,C3:U3,"<>"&$U$1)

Did you know that just off the top of your head?! I swear...I thought I tried everything and that just worked like a charm!!! THANK YOU!!!!

 

[Tetra201]

You are welcome.