Count

[Pradyumna89]

How to count no of times pain has been repeated in column 7 under data in column 1

1	2	6	7
2021306589	Out Patient	ACUTE	PAIN
		ACUTE	PAIN
		CJRONIC	PPI
		ACUTE	PAIN
		ACUTE	PAIN

[#2]

@Pradyumna89 

Try something like this...

=COUNTIFS(A:A,"<>",G:G,"PAIN")

Check the column reference in the formula. Currently, it is counting occurrences of "Pain" in Column G if there is data in Column A.