Forum Discussion
Formula should work but isn’t help please
I have a formula set in T12: =IF(COUNTIF(U8,">="&15)>=15, 45, 0) This should count if cell U8 has a value of 15 then T12 should have a value of 45 but when U8 reaches 15 it doesn’t add 45. Can some...
Okay where should I add that? This is the full formula.
=IF(AND(R12=1,COUNTIF(R:R,1)>=10),75,IF(R12=1,35,0))+IF(AND(S12=1,COUNTIF(S:S,1)>=5),75,IF(S12=1,35,0))+IF(AND(L12=1,COUNTIF(U8,15)>=15),45,IF(L12=1,20,0))
=IF(AND(R12=1,COUNTIF(R:R,1)>=10),75,IF(R12=1,35,0))+IF(AND(S12=1,COUNTIF(S:S,1)>=5),75,IF(S12=1,35,0))+IF(AND(L12=1,COUNTIF(U8,15)>=15),45,IF(L12=1,20,0))
