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 | X | Y | Risk | |
Task: Driving Risk: Confined Space | 0 | 0 | 0.00 | |
Task: Driving Risk: Electrical | 0 | 0 | 0.00 | |
Task: Driving Risk: Ergonomics | 2 | 3 | 6.00 | |
Task: Driving Risk: Explosion | 0 | 0 | 0.00 | |
Task: Driving Risk: Extreme Weather | 4 | 2.25 | 9.00 | |
Task: Driving Risk: Fire | 0 | 0 | 0.00 | |
Task: Driving Risk: Kinetic | 3.25 | 2.8 | 9.10 | |
Task: Driving Risk: Machinery | 0 | 0 | 0.00 | |
Task: Driving Risk: Noise/Hearing Protection | 0 | 0 | 0.00 | |
Task: Driving Risk: Public | 1 | 1.2 | 1.20 | |
Task: Driving Risk: Slip/Trip/Fall | 2 | 1.75 | 3.50 | |
Task: Driving Risk: Working Alone | 1.2 | 2.8 | 3.36 | |
Task: Driving Risk: Biological | 0 | 0 | 0.00 | |
Task: Driving Risk: Chemical | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Confined Space | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Electrical | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Ergonomics | 1 | 2.6 | 2.60 | |
Task: Phone Work Risk: Explosion | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Extreme Weather | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Fire | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Kinetic | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Machinery | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Noise/Hearing Protection | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Public | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Slip/Trip/Fall | 1 | 1.2 | 1.20 | |
Task: Phone Work Risk: Working Alone | 1 | 2.25 | 2.25 | |
Task: Phone Work Risk: Biological | 0 | 0 | 0.00 | |
Task: Phone Work Risk: Chemical | 0 | 0 | 0.00 |
<colgroup><col><col span="7"><col></colgroup><tbody>
</tbody>