Hello,

A cell in my financial statements has the following formula:
=GLAMT(D$8,RNGMERGE($B13,STRCAT("-",D$6)))

The problem is, it's not returning a value. I have a range of accounts in B13, and a department in D6.

Thanks

Sorry, any ideas what I'm doing wrong?

Thanks.

Jim:
What's in B13? The range should be XXXX:YYYY without any dash and "tick" at the end.