You may have to hit the Refresh button, or have ".AutoUpdate" in cell A2. If the department is in the range, then it will be included in the figures. If it isn't being included, then there is something other than security likely causing the problem.