Formula should work but isn’t help please

Copper Contributor

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?

2 Replies

@Rjh1798 

Perhaps

=45*(U8>=15)
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))