=COUNTIF not counting for me please help

[Patriot2879]

Hi I have the code below where I am trying to count words located in column H, I used the code below but it doesn't count anything just comes up with (0), can you help me please with this? any help will be greatly appreciated.

=COUNTIFS(Northants!H:H,"2 man ladder job",Northants!H:H,"Assist",Northants!H:H,"No parking",Northants!H:H,"ISCO Cut Out")

 

[mabalo76]

Try this
This is the range is always the same
=COUNTIF(Northants!H:H,"2 man ladder job") + countif(Northants!H:H,Northants!H:H,"Assist") + countif(Northants!H:H,"No parking") + countif(Northants!H:H,"ISCO Cut Out")

 

[mabalo76]

one typo corrected
=COUNTIF(Northants!H:H,"2 man ladder job") + countif(Northants!H:H,"Assist") + countif(Northants!H:H,"No parking") + countif(Northants!H:H,"ISCO Cut Out")

 

[Patriot2879]

brill that's great thank you so much, been trying to figure this out for ages, your a savior thanks again.

 

[MARZIOTULLIO]

	H​	I​	J​	K​	L​	M​
1​	name			criteria		total count
2​	2 man ladder job			2 man ladder job		7​
3​	Assist			No parking
4​	No parking			ISCO Cut Out
5​	ISCO Cut Out			Assist
6​	A
7​	B
8​	C
9​	No parking
10​	E
11​	ISCO Cut Out
12​	G
13​	No parking
14​	I

<tbody>
</tbody>

M2=SUMPRODUCT(COUNTIF(Northants!$H$2:$H$100,K2:K10))