R
ref at heart
Hello all,
What I need to do is when the formula below finds a number greater than 200
it needs to look in the corresponding row in the J column and verify that it
is greater than or equal to 145.
=COUNTIF(D4:F19,">=200")
D E F J
167 203 159 176
171 199 151 177
Don't believe you need the other information ~ but just in case.
Column G = D4+E4+F4
Column H = running total of colum G
Column I = =COUNTIF(D4:F4,">0")
Column J = =ROUNDDOWN(H4/I4,0)
thank you.
What I need to do is when the formula below finds a number greater than 200
it needs to look in the corresponding row in the J column and verify that it
is greater than or equal to 145.
=COUNTIF(D4:F19,">=200")
D E F J
167 203 159 176
171 199 151 177
Don't believe you need the other information ~ but just in case.
Column G = D4+E4+F4
Column H = running total of colum G
Column I = =COUNTIF(D4:F4,">0")
Column J = =ROUNDDOWN(H4/I4,0)
thank you.