LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 29
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif with Multiple Criteria No Idea Excel Worksheet Functions 3 May 15th 08 06:27 PM
Sumif multiple criteria? Alan Excel Worksheet Functions 3 May 6th 08 01:32 PM
SUMIF with multiple criteria Plum Excel Discussion (Misc queries) 4 April 21st 07 06:31 PM
SUMIF with multiple criteria stacyjhaskins Excel Worksheet Functions 4 August 29th 05 08:22 PM
SUMIF, multiple criteria Lauren753 Excel Discussion (Misc queries) 1 June 20th 05 08:28 PM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"