Results 1 to 29 of 29

Index / Match / Sum formula to show weekly figures

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Index / Match / Sum formula to show weekly figures

    I hope you guys can help me again. I originally posted and got my answer a while ago : http://www.excelforum.com/excel-form...ml#post3457010

    but now as a new year starts I want to extend the data, rather than have a sheet for each year. original question was :

    attached is a returns sheets that a qty is logged against part number every week.
    Some of the data I can use pivots on ( no problem ), but I have an issue on the returns tab where I think index/match / sum or something else will be better.
    At the moment because of the layout of data I have to drag each week number into the pivot value, do a greater than zero filter then summarize as a sum (yuk) I just cant get my head around index/match /sum, but can someone help?
    It would be great just to be able to enter a week number, and all the warehouse, part numbers and qty came through.
    There is a short explanation on the returns tab of what im looking for. Thanks in advance.

    so in essence I want week numbers across the top, but be able to enter a year on the returns tab that looks at the week number. I don't know enough about the formula to change.

    Thanks
    Attached Files Attached Files
    Last edited by interested; 01-15-2014 at 09:15 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index / Match / sum formula to show weekly figures
    By interested in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-30-2013, 05:44 AM
  2. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  3. [SOLVED] Formula to show alternate weekly team.
    By Ortz in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 07:02 PM
  4. Index Match: Show blank instead of #NA for no match
    By cedarhill in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2011, 03:21 PM
  5. Index and match function for Last Month figures
    By Harrold in forum Excel General
    Replies: 7
    Last Post: 03-09-2011, 04:24 AM

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