Here's how you'd do that:
  • Place the revenue or expense account range in column "B" with ".Range" in Column A
  • Make column "C" have the account description
  • Use the formula
    Code:
    =-GLAMT("Y","7"&RIGHT($Bn,4))

    for the YTD revenue amounts.
  • Use the formula
    Code:
    =GLAMT("Y","8"&RIGHT($Bn,4))

    for the YTD expense amounts.
  • Do the math for the net revenue.


Make sense?
_________________________
Andrew Bates