Andrew: I can't see anything wrong with the formulas. They read =GLAMT(F$6,$880) & =GLAMT(F$6,$870). The amount showing on the first one is (2,502.97) but when I click on it it displays the year transactions with a total of $16,895.73. The second one displays (18,573.63) and the balance of the year is 2,977.51. The current year is correct and all the other GL's are correct both current and past year. I thought when you drilled down it shows how the displayed amount is arrived at but in these two cases it isn't.