Wow. I can't understand the logic of a function only working on a range of more than one account. If it works for a range of something like 1010:1099, it should also work for 1010:1010, since it is still a range.

But the thing is, I tried it when the report was collapsed and the value of $B9 is 1010:1030-`. Still returned 0.00. 1010:1030 is 3 accounts: checking, savings, and petty cash. Tried hardcoding "1010:1030" which returned $1,160.19. No idea what that represents.