+ Reply to Thread
Results 1 to 2 of 2

Incorporate Moving Sum formula into my SUMIFS & also create 3 month moving average

  1. #1
    Registered User
    Join Date
    02-22-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    13

    Incorporate Moving Sum formula into my SUMIFS & also create 3 month moving average

    I am utilizing a SUMIFS formula to sum volume from multiple rows based on multiple criteria.
    I would like to incorporate another formula into my current SUMIFS formula or create new formula in order to calculate a moving sum, last 3 months instead of total (month indicated in additional column K.)

    I would also like to calculate a 3 month moving average based on the criteria from my SUMIFS in column C. (Customer & Region) + Month

    Please see attached Spreadsheet, is it a problem that the months are formatted as text?
    Revised_Multile vlookup values Then Sum-Example TMS.xlsx

    Thank you,
    Price
    Thank you for the assistance!

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Incorporate Moving Sum formula into my SUMIFS & also create 3 month moving average

    I believe this may be what you are looking for, but please correct me if I'm wrong. In cell D2, paste the following and drag down:

    Please Login or Register  to view this content.
    In cell E2 paste the following and drag down:

    Please Login or Register  to view this content.

    *Forgot to mention that I did format the K column as text for this problem
    Last edited by mcmahobt; 10-20-2014 at 03:36 PM.

+ 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. [SOLVED] Help with Formula Placement for 12 Month Centered Moving Average
    By jmlowmanekdp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2014, 03:23 AM
  2. Replies: 4
    Last Post: 05-24-2013, 01:24 PM
  3. 3 month moving average
    By braydon16 in forum Excel General
    Replies: 4
    Last Post: 11-23-2011, 02:32 PM
  4. 3 Month Moving Average Dashboard
    By DUKE888 in forum Excel General
    Replies: 2
    Last Post: 11-02-2011, 01:52 PM
  5. [SOLVED] how do i chart a 24 month moving average of sales shipments
    By lostinred in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-20-2005, 09:05 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