Need help with count specific column

[Lukma]

Hi Friends

Please can some help out with a solution to this count of specific cell i need

i have my Table Header List with unique name for this column which Location/Site Rig Move and i need to count Rig name is input in AG
Solution i need to count only this column E7, K7, P7, V7, AA,
Example if Column E7 = Text column AG count = 1
and If E7 and K7 = Text column AG count =2

Appreciate with any solution to count this specific column only

Shipping Vessels Activity & Voyage Plan Log.xlsx
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
6	Location/ Site Rig-move	TotalLift	Cargo Ton	Bulk Type	Bulk Mt	Total Plan	Location/ Site Rig-move	TotalLift	Cargo Ton	Bulk Type	Bulk Mt	Location/ Site Rig-move	TotalLift	Cargo Ton	Bulk Type	Bulk Mt	Total Plan	Location/ Site Rig-move	TotalLift	Cargo Ton	Bulk Type	Bulk Mt	Location/ Site Rig-move	TotalLift	Cargo Ton	Bulk Type	Bulk Mt	Total Plan	Total Plan
7	Al Ghallan Island						Al Ghallan Island			Elasticem																			0
8
Shipping Voyage Log

Cell Formulas
Range	Formula
AG7	AG7	=COUNTIFS(INDEX(E7:AF11,,ROWS($E$6:$AF$6)),E7:AF7)

Cells with Data Validation
Cell	Allow	Criteria
K7:K8	List	=Info!$D$4:$D$81
P7:P8	List	=Info!$D$4:$D$81
V7:V8	List	=Info!$D$4:$D$81
E7:E8	List	=Info!$D$4:$D$81
AA7:AA8	List	=Info!$D$4:$D$81
N7:N8	List	=Info!$F$4:$F$25
S7:S8	List	=Info!$F$4:$F$25
Y7:Y8	List	=Info!$F$4:$F$25
H7:H8	List	=Info!$F$4:$F$25
AD7:AD8	List	=Info!$F$4:$F$25

 

[jasonb75]

COUNTA should work for that

=COUNTA(E7,K7,P7,V7,AA7)

 

[Lukma]

COUNTA should work for that

=COUNTA(E7,K7,P7,V7,AA7)

Jasonb75
Thanks so much

Regards