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: 5
Default Sum Order and Vendor Orders from Pivot Table for Given Month

I could use some assistance with counting the number of orders and vendor
orders for a given month. I have Date Order Accepted in one column, Delivery
Order in another, and Vendor Order in another. Because multiple orders (both
DO and VO) can be issued on the same day, the Date Order Accepted is listed
once for a given date, and the two orders associatd with it are obviously
grouped together, but with DO having one order and VO having the other. How
do a count the number of orders issued in a given month? I believe if I
could figure this out, I could expand my summary worksheet to capture the
total value of the orders reported for a given month. Of course, if someone
could help with that, it would be appreciated as well.
 
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
Pivot Table Order Not Functioning Jeff Eubanks Excel Discussion (Misc queries) 2 January 25th 07 09:40 PM
Pivot Table out of order reno Excel Discussion (Misc queries) 2 August 24th 06 08:42 PM
Pivot table sort order Vincdc Excel Discussion (Misc queries) 2 March 1st 06 05:20 PM
pivot table column order sennr Excel Discussion (Misc queries) 4 January 19th 06 10:17 PM
How do I change the order of my pivot table? NJ_Mike Excel Discussion (Misc queries) 2 July 21st 05 10:26 PM


All times are GMT +1. The time now is 05:44 PM.

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"