The formula that is being used is-`,=ADGET("GLDATA.BAL",$B13), which is adding one single account and two ranges of accounts as follows 1320,8000:8999-`,2900:2999-`,. We did figure out what was happening. I did not have the accounts listed in numerical order, so the accounts listed as 1320,8000:8999-`,2900:2999-`did not work, but 1320,2900:2999-`,8000:8999-`,did. So I guess you need to put the accounts in the numerical order in order for it to add all the accounts in.