Hello everyone,

I have an issue with the following formula:

=IF(C1="OPM", IF(E1="Day", COUNTA(OPMTesterDay), COUNTA(OPMTesterNight)), IF(E1="Day", COUNTA(FTTesterDay), COUNTA(FTTesterNight)))

Where OPMTesterDay is a Defined Validation list and its reference looks like:
=OFFSET(People!$C$1,0,0,COUNTA(People!$C$1:$C$14)-COUNTBLANK(People!$C$1:$C$14),1)

The issue is that as you populate the lists with names, the formula seems to work just fine and show only the remaining number of unallocated resources. However it never seems to show the value "0".

Can you please help me with this issue?