Using RNGMERGE you can specify the departments you want on a cell as you do with the accounts such as:
B8 = '20,22,27


E20=GLAMT(E$9,RNGMERGE($B20,STRCAT("-",$B$8)))
_________________________
Patricia Balbuena Cotlear
AP SMART SUPPORT
236 991 3060