Sumif with multiple criteria
 

Thank you in advance whoever can help me with this problem. I am using a
Pivot Table that looks like this:

DEPT [10000] - (Page)
Data
Type Account Description Period Sept Oct Nov
Revenue 75500 Cash LY 2007 1,000 1,500 0
FY 2008
500 0 1,000
Budget '08
1,500 1,500 1,500

Depending on the dept selected, I need to add the Revenue by Period by Month
and add the Expenses (below Revenue in Pivot Table) by Period by Month and
then simply show the surplus/deficit at the bottom.

I have been racking my brains with this one as for some reason the pivot
table report will not allow me to subtotal by period.

Huge thanks!!

Tammy.


--
Thanks for your help!

Sumif with multiple criteria
 

Try Data Subtotal. Some examples he
http://www.ozgrid.com/Excel/subtotal.htm

http://www.jegsworks.com/Lessons/num.../subtotals.htm

http://www.jegsworks.com/Lessons/num...p-subtotal.htm


Regards,
Ryan---

--
RyGuy


"TamIam" wrote:

Thank you in advance whoever can help me with this problem. I am using a
Pivot Table that looks like this:

DEPT [10000] - (Page)
Data
Type Account Description Period Sept Oct Nov
Revenue 75500 Cash LY 2007 1,000 1,500 0
FY 2008
500 0 1,000
Budget '08
1,500 1,500 1,500

Depending on the dept selected, I need to add the Revenue by Period by Month
and add the Expenses (below Revenue in Pivot Table) by Period by Month and
then simply show the surplus/deficit at the bottom.

I have been racking my brains with this one as for some reason the pivot
table report will not allow me to subtotal by period.

Huge thanks!!

Tammy.


--
Thanks for your help!