I didn't want to reverse engineer what's going on in the calcs you have.
Are you trying to force a zero where no value exists?
See the attached. I have displayed [Person Count] and below it a forced zero (or [Person Count] if it exists) using LOOKUP. See sheet 3.