Find the number of times a number >0 appears with a criteria of a certain word

[phaneufs]

[TABLE="width: 847"]
<colgroup><col><col span="7"><col></colgroup><tbody>[TR]
[TD="colspan: 5"]Alright,

So I am having trouble with trying to find a formula that works for me here without getting an error. What I am trying to do is find the Risk numbers (X*Y) that are greater than 0 for each risk. Basically I want to know given the risk "Kinetic" how many times does the risk have a number greater then zero so the answer I should be getting is 1 since Task: Driving Risk: Kinetic is 9.10 and Task: Phone Work Risk: Kinetic is 0. I'm stuck on this and tried multiple formulas. Any help would be greatly appreciated! What I have came up with that I thought would work is the following:

=COUNTIFS(A:A,ISNUMBER(FIND("Kinetic",$A:$A)),$I:$I,ISNUMBER(FIND("0",$I:$I)))

I also have this but this only finds the maximum number and does not count the numbers.

=SUM(IF(ISNUMBER(FIND("Kinetic",$A:$A)),$I:$I))



List Items[/TD]
[TD]










X[/TD]
[TD]










Y[/TD]
[TD] [/TD]
[TD]

Risk​

[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Confined Space[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD] [/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Electrical[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Ergonomics[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[TD="align: right"]6.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Explosion[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Extreme Weather[/TD]
[TD]4[/TD]
[TD]2.25[/TD]
[TD][/TD]
[TD="align: right"]9.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Fire[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Kinetic[/TD]
[TD]3.25[/TD]
[TD]2.8[/TD]
[TD][/TD]
[TD="align: right"]9.10[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Machinery[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Noise/Hearing Protection[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Public[/TD]
[TD]1[/TD]
[TD]1.2[/TD]
[TD][/TD]
[TD="align: right"]1.20[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Slip/Trip/Fall[/TD]
[TD]2[/TD]
[TD]1.75[/TD]
[TD][/TD]
[TD="align: right"]3.50[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Working Alone[/TD]
[TD]1.2[/TD]
[TD]2.8[/TD]
[TD][/TD]
[TD="align: right"]3.36[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Biological[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Driving Risk: Chemical[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Confined Space[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Electrical[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Ergonomics[/TD]
[TD]1[/TD]
[TD]2.6[/TD]
[TD][/TD]
[TD="align: right"]2.60[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Explosion[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Extreme Weather[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Fire[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Kinetic[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Machinery[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Noise/Hearing Protection[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Public[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Slip/Trip/Fall[/TD]
[TD]1[/TD]
[TD]1.2[/TD]
[TD][/TD]
[TD="align: right"]1.20[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Working Alone[/TD]
[TD]1[/TD]
[TD]2.25[/TD]
[TD][/TD]
[TD="align: right"]2.25[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Biological[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"]Task: Phone Work Risk: Chemical[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Try

=COUNTIFS(A:A,"*Kinetic*",I:I,">0")

 

[phaneufs]

Worked perfect! Thank you!

 

[Jonmo1]

You're welcome.