How to make a one point conditional mark in a column

Can anyone explain in a simple way what I have missed in this formula.
I don’t get the expected result (please see attachment).

=IF(OR(COUNTIF(A6:$A$11;$D$1);IF(AND($C$11>SUM(B5:$B$11);(B5/2)>(SUM(B5:$B$11)-$C$11));"";$D$1));"";$D$1)

Tommy

The OR construct won't evaluate correctly given Null population and you need to adjust the reference in COUNTIF in A11 such that it does not refer to itself.

It's hard to know what the adjust should be given the logic has yet to be outlined - I suspect your formula should read:

Please Login or Register  to view this content.

but it still wouldn't return "expected" result....

Perhaps best to outline what the calculation is meant to be doing ... presumably along similar lines to that of your prior thread re: ramp up.