#VALUE with Nexted IF/AND Statements

Without trying to follow the formula's logic, the simple fix would be:

=IF(COUNT(E4:F4)=2,your current formula,"")

Actually, after a closer look, I don't see any reference to E4 in the formula. That being the case then just this would suffice:


=IF(F4="","",your current formula) don't forget the extra ) at the end