I am trying to produce a financial report summarizing our income and expenses as follows:

Actual YTD Bud YTD Variance
Revenue
Dept 1 100 90 10
Dept 2 350 400 (50)
Dept 3 150 125 25

Total Revenue 600 615 (15)

Expenses
Dept 1 90 85 5
Dept 2 300 340 (40)
Dept 3 100 110 (10)

Total Expense 490 535 (45)

Surplus(Deficit) 110 80 30

We have over 25 departments and I would like a one or two pager that just sumarizes the revenues and expenses by dept. Basically our revenue codes range from 5000-5999 and expenses from 6000-6999. How would the formuala be structured to segregate only the revenues in a range from 5000-5999, by each department?

Thanks,

Ken