I need to work out the availability for each service in a particular room if its is assigned to that room given that the total occupants do not exceed the total capacity of the room. Please see attached. Help will be most appreciated. Cheers!

excel help.png