Forum Discussion
Nesting a COUNTIF With IF To Evaluate A Formula
Hello RangerLG​,
If the goal is to leave the result blank when no training is required, you don't need to combine COUNTIF with your existing formula. Wrap your calculation in an IF statement that checks whether the training is required.
For example, if Documents!B3 contains "Required":
=IF(Documents!B3<>"Required","",COUNTA(Documents!C3:C5)/3)
If the training is required, the formula returns the completion percentage. If it isn't required, it returns a blank.
If you don't already have a field that indicates whether training is required, how does your workbook identify employees who don't need that training? That will determine what condition to use in the IF statement.
I suspect that what you're trying to do is fairly easy. Unfortunately, I don't really know what it is you're trying to do and your explanation is, frankly, not clear enough to really get a grasp on what that is. Is it possible for you to attach a copy of your workbook--removing any real identities, replacing them with Disney character names, as well as concealing any other proprietary data (e.g., if there is possibility of inferring too much from the names of the safety training modules. You should be able to attach such a sample sheet to your reply. If not, then post it in Google Drive or Drop Box and post a link here.