Results 1 to 3 of 3

Trying to get Monthly Summary based on QTY per

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2016
    Location
    New York
    MS-Off Ver
    2016
    Posts
    20

    Trying to get Monthly Summary based on QTY per

    Hi Team!!

    Gosh I miss this place
    Now that I am done buttering you all up, I have a relatively simple question that is yet again just outside my realm of skills and can't seem to solve this riddle without an array formula. Please see the attached excel document.

    The data I have to work with is in columns A through J and the desired output is highlighted in yellow. What I want to do is take the monthly data in columns A:C and multiply it by the "QTY Per" in H based on 2 different things being product family (in column F) and model number (column J) to get the desired output on the right. I would imagine both formulas would be very similar.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for monthly summary
    By penza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2016, 02:35 PM
  2. Replies: 3
    Last Post: 02-03-2016, 01:53 PM
  3. Monthly spreadsheet- need to update summary sheet based on date
    By hootiebsc in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-08-2013, 02:17 PM
  4. Monthly summary of weekly output based on customized calendar
    By thisisgerald in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2012, 08:01 AM
  5. [SOLVED] Monthly Summary Based on Weekly Dates
    By thisisgerald in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-14-2012, 04:49 AM
  6. [SOLVED] Monthly Summary and SUMIF
    By General Specific in forum Excel General
    Replies: 6
    Last Post: 11-20-2005, 11:20 AM
  7. [SOLVED] Monthly Summary of Data
    By proshail in forum Excel General
    Replies: 1
    Last Post: 07-08-2005, 05:05 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