How to make a one point conditional mark in a column

[tomjoe]

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

[DonkeyOte]

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.

[tomjoe]

Thank you DonkeyOte you helped me in the right direction.
This one did the trick:
=IF(OR(COUNTIF(A12:$A$12,$D$1)>0,($C$11>SUM(B11:$B$11)*0,8)),"",$D$1)