+ Reply to Thread
Results 1 to 4 of 4

Add up order quantities and show date required summary

  1. #1
    Registered User
    Join Date
    08-28-2008
    Location
    NSW Australia
    Posts
    15

    Add up order quantities and show date required summary

    Hello, I am really hoping someone may be nice enough to help me out with this one. I think it should be pretty simple for folks on here.
    We have some meal orders coming in from the online store, on a daily basis I need to email a summary to the chefs showing the food to me made in the coming days.
    I am not sure if I should use a pivot table? or what? here are a couple of pics:

    Order-Details.xlsx - Excel.png

    Order-Details.xlsx - Excel-Pivot-Table.png

    And here is some sample data should be attached.

    I clearly dont know what Im doing and I have put a pivot table in there..The summary would be fine if thats how it looked but the totals shown on my pivot table are wrong. I think it is because it is only adding the first reference to an item and missing the others.

    Thank you very much
    Miked
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Add up order quantities and show date required summary

    You will have the Sigma values set to show COUNT not SUM. So change it to SUM and it's fine.
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    08-28-2008
    Location
    NSW Australia
    Posts
    15

    Re: Add up order quantities and show date required summary

    Hello Glenn,
    I cannot thank you enough. I know it was a silly question but I didnt know much about how pivot tables work. I will be trying to improve in the future.
    Thanks once again for spending the time

    Michael

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Add up order quantities and show date required summary

    No problem. There's no such thing as a silly question. if you don't know... you don't know.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using Quantities to automatically populate a purchase order
    By Richard P in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2016, 05:42 AM
  2. [SOLVED] index match to show in date order
    By nigelog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2015, 10:03 AM
  3. Replies: 2
    Last Post: 05-07-2014, 01:12 PM
  4. Only show quantities of three or greater???
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2014, 12:44 PM
  5. Create summary of quantities by an interval
    By SueWithQuestion in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2011, 09:33 AM
  6. Summary Sheet in order by date
    By lacey125 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2006, 05:53 PM
  7. [SOLVED] Rounding up results to meet minimum order quantities.
    By Vin C. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2006, 02:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1