Forum Discussion

Rjh1798's avatar
Rjh1798
Copper Contributor
Mar 22, 2023

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 someone see an issue with this?

Formulas and Functions
    • Rjh1798's avatar
      Rjh1798
      Copper Contributor
      Mar 22, 2023
      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))

Resources