=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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[TD]

J​

[/TD]
[TD]

K​

[/TD]
[TD]

L​

[/TD]
[TD]

M​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD]criteria[/TD]
[TD][/TD]
[TD]total count[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]2 man ladder job[/TD]
[TD][/TD]
[TD][/TD]
[TD]2 man ladder job[/TD]
[TD][/TD]
[TD]

7​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Assist[/TD]
[TD][/TD]
[TD][/TD]
[TD]No parking[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]No parking[/TD]
[TD][/TD]
[TD][/TD]
[TD]ISCO Cut Out[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]ISCO Cut Out[/TD]
[TD][/TD]
[TD][/TD]
[TD]Assist[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]No parking[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]E[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]ISCO Cut Out[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD]G[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD]No parking[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD]I[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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