View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Sum Order and Vendor Orders from Pivot Table for Given Month

Could you type a few rows of sample data into a message, and explain the
result that you'd like to see in your pivot table, from that sample data?

vstar wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html