Worked great. One more quick question.

I'm using the formula =ADDRONLY("GLDATA.OPEN",$B9) to give me my opening balance. Cell B9 has the account. Some accounts have multiple departements. I have all the departments in column C. For example for account 1010-1 (where 1010 is the account and 1 is the department) I have "1010" in B9 and "1" in C9.

How do i tell the forumula to get the balance for that account-department combination?

Thanks!